DateDiff
Last updated
Was this helpful?
Last updated
Was this helpful?
Returns a number that is the difference between two dates in a specific unit. If one of the two dates is unknown then this function returns unknown.
Returns Unknown
if one of the parameter values is unknown or outside the common valid date boundaries.
start_date
date time
the start date
end_date
date time
the end date
unit
Keyword
the date unit of which the difference is calculated. Possible values: years, months, weeks, day, hour, minute or second.