Date Time to Second

[Monsora83]

Hi All,

Im trying to convert a value like 8/31/2012 2:36:14pm into just seconds.

Any suggestions? Most what I find in google only tells me how to convert the hours and not the date as well.

Thanks

 

[Trevor G]

Is it based on an actual date not a date period?

 

[Monsora83]

Is it based on an actual date not a date period?

I'm not sure I understand the difference.

 

[Trevor G]

OK what about this type of Expression in a Query

Expr1: Hour([StoredDate])*3600+Minute([StoredDate])*60+Second([StoredDate])

 

[Monsora83]

Ah I found something that got me what I needed.

DateDiff("s", Me.Time1, Me.Time2)

Thanks