Calculate Date Difference Between Two Dates in Days

[Angelo_Sunny]

What is your goal?

I want to calculate the no of days from a difference of 2 dates

What is the problem & what have you tried?

i tried diff formulas to get the no.of days but everytime the variable module is ran the output is empty
{{floor((now - parseDate( (Due Date); “YYYY-MM-DD”)) / 86400000)}}

Error messages or input/output bundles

empty

[Stoyan_Vatov]

Hey Angelo,

here.

[samliew]

Welcome to the Make community!

Pretty simple, if you have my custom app installed.

You don’t need to use any functions.

You’ll get the difference between the dates, in various formats and units, use the one that you need.

For more information, see [App] Sam's Toolbox of Useful Modules: @samliew

Hope this helps! If you are still having trouble, please provide more details.

— @samliew
_{P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!}

[Msquare_Automation]

Hi @Angelo_Sunny ,

You can calculate the difference between two dates, as well as the difference between a given date and the current date, by using the formulas shown in the screenshots.

For calculating the difference between two dates, you can parse both date values and subtract them, then convert the result from milliseconds to days.

For calculating the difference between a date and the current date, you can use the same approach by replacing one of the dates with now().

If you face any issues while applying these conditions, please share the input bundles so the problem can be reviewed and clarified more effectively.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation