Click to See Complete Forum and Search --> : Noon to midnight formula help


Nepboard
February 15th, 2007, 12:08 PM
I'm trying to write a custom formula to only show records that happened between noon and midnight over a specific date range. I have no problem with the date range but the time thing is killing me. The start time is in the ({Trips.calltime} table. The ending time is located in the {Trips.atstime} table. Thanks!

JaganEllis
February 15th, 2007, 06:06 PM
What does 'happened' mean? Started on/after 12pm? Is the end time relevant?
Try the Time function, e.g.

and time({trips.calltime}) >= time(12,0,0)