Description
Evaluates the DateTime value and returns the number of seconds that have passed between 00:00:00 (12:00 midnight) and the specified time.
Arguments
dateTime is a DateTime value.
Returns
Time value (in seconds)
Action
Evaluates the DateTime value and returns the number of seconds that have passed between 00:00:00 (12:00 midnight) and the specified time.
Examples
DateTimeToSeconds(#11/01/1998 11:30:15 AM#)
Returns 41415.
Comments
Instead of using DateTimeToSeconds (dt), you can use:
DateDiff ("s", #12:00 am#, CDateTime (CDate(0,0,0), CTime (dt)))
The above expression does not use UFLs and can be more efficient.