Crystal Reports date formula

[IanHallett]

I have what is hopefully a simple question regarding the syntax of a date formula.

I have a date field that I want to check against to see if it is before or after 9am, I have tried a number of variations of the formula below but cannot get it to work

If ({TimeField})>"09:00" then 1 else 0

Any help would be greatly appreciated.

 

[lbass]

if {table.time} > time(9,0,0) then 1

-LB

 

[IanHallett]

Perfect thanks, exactly what I needed.