Time reference in query

[miacino]

=iif([actual start time]>#2:59 PM#,"OT","")

[actual start date] is a time field in the query. Trying to use this expression in the query to determine OT.

Yields error: The expression you entered contains invalid syntax. You may have entered an operand without an operator.

I'm not proficient in VB/programming, so sorry for my naivity. Can anyone help?

Thank you!
Michele

 

[pbaldy]

In a query you wouldn't want the "=".

 

[pbaldy]

Just tested to be sure, and this worked as expected:

IIf([FieldName]>#14:59:0#,"OT","")

 

[miacino]

Thank you!

 

[pbaldy]

Happy to help!