convert time to seconds

[deesheeha]

Hi, i have a date variable which captures the time when a button is pressed. does anyone know how i can covert this to seconds?? as when its stored in a table its stored as an integer

 

[randy700]

Perhaps... cint(yourdatevariable) ?


Randy

 

[deesheeha]

hmm, that didnt work. let me show you my code

dim CallLength As Date
MsgBox CallLength, vnOKOnly <--- returned 00.33.30
CallLength = CInt(CallLength)
MsgBox CallLength, vbOKOnly < --- returned 00.00.00

 

[Golom]

You want just the Time portion of a DateTime field converted to seconds?

nSeconds = Int(86400 * TimeValue([DateField]))

 

[deesheeha]

thanks golom, that worked perfectly!

 

[SkipVought]

Hi,

FYI. TIME is part of Date/Time as is in UNITS of DAYS.

Simple third grade arithmetic to convert from DAYS to SECONDS.

Skip,

_[red][/red]