How can I have negative value between dates using daysBetween ?
daysBetween functions seems like just returning absolute values. If yes, then how can I get days between two dates that considers negative values?
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)
Or use the abs function like abs(daysBetween(date1,date2)).