botbunz 0 Posted September 18, 2019 Report Share Posted September 18, 2019 Hi, How do I compare 01/12/2019 (DD/MM/YY) - 20/12/2019 to get number of days between these two dates? Thanks Quote Link to post Share on other sites
kill3rbko 12 Posted September 18, 2019 Report Share Posted September 18, 2019 hi, you can substract the 2 dates after inversed. you must transform the date to that format without "/" : YYYYMMDDThen you will get the number of days by doing 20191220 - 20191201 Good luck Quote Link to post Share on other sites
HelloInsomnia 1103 Posted September 18, 2019 Report Share Posted September 18, 2019 hi, you can substract the 2 dates after inversed. you must transform the date to that format without "/" : YYYYMMDDThen 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") Quote Link to post Share on other sites
botbunz 0 Posted September 19, 2019 Author Report Share Posted September 19, 2019 Could we please make the date tome plugin available? Do you have the link please? Thanks Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.