Description
Evaluates the string specified and converts the Time value to the number of seconds from 00:00:00 (12:00 midnight) to the specified time.
Arguments
DateTimeString is a string including a Date and a Time value.
Action
Evaluates the string specified and converts the Time value to the number of seconds from 00:00:00 (12:00 midnight) to the specified time.
Examples
DTSToSeconds("2000/01/13 11:30:15")
Returns 41415.
Comments
Instead of using the DTSToSeconds function, you can use:
DateDiff ("s", #12:00 am#, CDateTime (CDate(0,0,0), CTime (DateTimeString)))
The above expression is able to convert more types of strings.