DateTimeDiff
- get difference in seconds between two datetime values

Date/Time
(AFL 3.30)


SYNTAX DateTimeDiff( arg1, arg2 )
RETURNS NUMBER or ARRAY
FUNCTION DateTimeDiff( arg1, arg2 ) which will return positive values if arg1 > arg2 and negative values if arg1 < arg2.

The difference is given in seconds.

The function can operate on scalar and array arguments, returning scalar if both inputs are scalars, and array otherwise.

It is important to understand that DateTime is not a simple number but rather bitset and two datetime values can only be reliably compared for equlity or inequality using == or != operators. Any other comparisions (less than/greater then), using normal operators > < may sometimes lead to wrong results (if one of dates compared is pre-1964), therefore to compare two datetime numbers reliably you should use DateTimeDiff.

EXAMPLE
SEE ALSO DateTime() function

References:

The DateTimeDiff function is used in the following formulas in AFL on-line library:

More information:

Updated on-line reference