DateTimeDiff
|
Date/Time |
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 |
The DateTimeDiff function is used in the following formulas in AFL on-line library:
See updated/extended version on-line.