How To Compare Two Dates

[botbunz 0]

Hi,

 

How do I compare 01/12/2019 (DD/MM/YY) - 20/12/2019 to get number of days between these two dates?

 

Thanks

 

[kill3rbko 12]

hi,

 

you can substract the 2 dates after inversed.

 

you must transform the date to that format without "/" : YYYYMMDD

Then you will get the number of days by doing

 

20191220 - 20191201

 

Good luck

[HelloInsomnia 1103]

hi,

 

you can substract the 2 dates after inversed.

 

you must transform the date to that format without "/" : YYYYMMDD

Then you will get the number of days by doing

 

20191220 - 20191201

 

Good luck

 

This won't work unless the dates are in the same year and month.

 

One way is to convert the dates to a unix timestamp, subtract and then divide the result by the number of seconds in a day (86,400)

set(#startDate,$plugin function("DateTime Manipulation.dll", "$datetime manipulation", "12/01/2019", "MM/dd/yyyy", "UNIX", "en-US", "en-US"),"Global")
set(#endDate,$plugin function("DateTime Manipulation.dll", "$datetime manipulation", "12/19/2019", "MM/dd/yyyy", "UNIX", "en-US", "en-US"),"Global")
set(#difference,$divide($subtract(#endDate,#startDate),86400),"Global")

[botbunz 0]

Could we please make the date tome plugin available? Do you have the link please? Thanks