Question

CurrentDate subtraction from date

1

how can I subtract current date from due date, in order to determin how many days (as Integer) are left until the due date? Also when i use the function addWeeks() the date format changes from dd/MM/yyyy to MM/dd/yyyy - is there a workaround?

asked 2010-11-11

Karol

2 answers

4

You can subtract the current date from the due date with the 'trimToDays' function.

answered 2010-11-11

Marco Keijsers

Alexander Willemsen · Accepted Answer · 2010-11-11

daysBetween([%CurrentDateTime%], $dueDate)

(See also the documentation)

This returns a float value, so you'd probably want to use either round(), ceiling() or floor() (depending on how you want to count partial days) on the result to get an integer value.