Comparing times

[52strong]

Dear all,

Please help! I have two string fields in my database which are actually times. I can successfully convert these to valid time fields using the timevalue function. However, I need to be able to work out the differences between these two times and it doesn't seem to be working.

Help!
Ta

 

[rosemaryl]

Dear 52strong,

Concatenate the currentdate onto the field and then use a datediff to get the difference in seconds.

Example:

datediff("s",currentdate + timevalue(6,03,32),currentdate + timevalue(9,52,32))

Hope that helps,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.