G
Guest
Good day.
I am trying to assign a number between certain times.
For example:
From 8 am to 4 pm is shift 2. How would I put this into Syntax. I tried this
but does not seem to work
=IIF([TIME_ON]<08:00 and >16:00, 1,0)
Any help would be greatly appreciated. I am placing this calculation in a
query.
Cheers
I am trying to assign a number between certain times.
For example:
From 8 am to 4 pm is shift 2. How would I put this into Syntax. I tried this
but does not seem to work
=IIF([TIME_ON]<08:00 and >16:00, 1,0)
Any help would be greatly appreciated. I am placing this calculation in a
query.
Cheers