Getting day count from a date?


In my variable I have a date looking like 02/01/2014 I want to get the count from this date till today. How many days difference is there? I would like to save the result as a variable which should a numerical number.
How can I achieve this?

Thanks for your help.

  • Use the Search Variable action to split the 02 01 and 2014 in to component parts.
  • Use the TIME function to turn that into a time since 1970.
  • Subtract that from TIME() which is NOW().
  • Divide the result by (24*3600) to get the number of days difference.
  • Use the TRUNC function to round down.
1 Like

Take a look at this macro:

Date Calculator

You can probably use parts of this macro for your use case.

1 Like

Guys, thank you very much for your assistance. I am seriously having difficulty performing the actions required. Could you provide further guidance?

Many thanks for your understanding.

Please post whatever macro you have so far, and list the specific questions you have.