Time Diff Calculations inside Query.

[cap.zadi]

Hey there,



Sorry to bother you there. i am sure some one will come up with solution.

I have one query where looking to calculate the diff of time like.

StopTime: 07:00AM
RestartTime: 07:00PM

it works but if i go in reverse from PM to AM so it shows the Minus values.

please advise which format i shell i keep for date fields so calucaltions can be correct one.

thanks

zee

[Robeen]

Instead of calculating using just the Time, you could try calculating using the Date AND Time.

[cap.zadi]

well, yes thanks its been solved already. i shoud keep the field format as General Date and use the date and time bcz when it said 7pm to 7 am so means date change to next day. anyways thanks for advise.