DATEDIFF Function
Function Type | Predefined function | ||
Syntax | DATEDIFF( <interval>, <dateValue1>, <dateValue2> ) | ||
Description | Determines the number of time intervals between two dates. | ||
Argument | Description | ||
<interval> | String describing "part" of the time interval used to calculate the difference between two date arguments. Shown below is a list of valid time interval parts: | ||
Time Parts | Interval Value | ||
Year | y | ||
Quarter | q | ||
Month | M | ||
Day of Year | D | ||
Day of Month | d | ||
Weekday | E | ||
Week | w | ||
Hour in am/pm (1-12) | h | ||
Hour in day (0-23) | H | ||
Minute | m | ||
Second | s | ||
The intervals for Day of Year ("D"), Day of Month ("d"), and Weekday ("E") can be used interchangeably to determine the difference between the two dates in days. | |||
<dateValue1> | Date type representing the first date to be used in the difference calculation. | ||
<dateValue2> | Date type representing the second date to be used in the difference calculation. | ||
Returns | Integer. DATEDIFF returns a negative integer if the first date parameter is more recent than the second date parameter. If the second date is more recent, it returns a positive integer. | ||
Example | This example writes the difference between dates in the source fields, Field1 and Field2 (in number of days). DATEDIFF("d",Source.Table1.Field1,Source.Table1.Field2) | ||