Calculates the difference between two DATETIME values.
iDaysDiff = DiffDateTime (DateTime1, DateTime2 [,iHours, iMinutes, iSeconds, iMicrosecs])
|iDaysDiff||The returned difference in days resulting from subtracting DateTime2 from DateTime1. INTEGER.|
|DateTime1||The DATETIME value from which DateTime2 is subtracted. DATETIME.|
|DateTime2||The DATETIME value to be subtracted from DateTime1. DATETIME.|
|iHours||Optional. The Hours component of the difference between DateTime1 and DateTime2. out INTEGER.|
|iMinutes||Optional. The Minutes component of the difference between DateTime1 and DateTime2. out INTEGER.|
|iSeconds||Optional. The Seconds component of the difference between DateTime1 and DateTime2. out INTEGER.|
|iMicrosecs||Optional. The Microseconds component of the difference between DateTime1 and DateTime2. out INTEGER.|
The return value is just the Days component of the difference between the DATETIME values. The hours, minutes, seconds, and microseconds differences are returned in optional out arguments.
To skip over an optional argument, use NULL as a placeholder.
You can use the optional out arguments to specify variables that receive the corresponding field from the calculated difference. In the first example below, the function returns difference values for days, hours, minutes, and seconds-ignoring microseconds. In the second example, the only values of interest are in the minutes, seconds, and microseconds fields of the difference and those are the only values returned.
iDaysDiff = DiffDateTime (CurrentDate, LastDate, iHoursDiff, iMinsDiff, iSecsDiff) DiffDateTime (CurrentDate, LastDate, NULL, iMinsDiff, iSecsDiff, iMicrosecs)