How can I have negative value between dates using daysBetween ?

0
daysBetween  functions seems like just returning absolute values. If yes, then how can I get days between two dates that considers negative values?
asked
2 answers
2

The daysBetween function always returns a positive number. However you can use an if expression to determine if it is negative or not.

if date1 > date2 then
  -1 * daysBetween(date1, date2)
else 
  daysBetween(date1, date2)

 

answered
-1

Or use the abs function like abs(daysBetween(date1,date2)).

Regards,

Ronald

 

answered