Operator Type:
Operator Scope of Action:
Operator Purpose:
Operator First Added:
Operator Altered:
Function [other Function type actions]
Item [operators of similar scope]
Date-time [other Date-time operators]
Already in v5.0.0
days(date1,date2)
returns the number of 'days' (as defined below) that elapsed between date1 and date2. If date 2 is earlier than date1 then the result is negative.
The operator returns the number of 24-hour blocks [sic] between two dates, rounded toward zero. So if days() measures the difference between a date/time of 09:30 today and 08:30 tomorrow, the result is 0 (zero) as the difference is only 23 hours. If the times are same a whole day increment is recorded.
Thus days does not return a simplistic calendar day difference as some users might intuit it would. If times vary between date1 and date2, the returned difference figure may thus be one day high or low of an expected calendar day-based value.
Also see minutes(date1,date2).