Getting day count from a date?

Questions & Suggestions
1

Hi,

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.

2
  • 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
3

Take a look at this macro:

Date Calculator

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

1 Like
4

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.

5

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