T
TDC
I have a table with a time field that displays a long form time (12:00:00 AM)
by default. Through a query I want to build a work shift field for grouping
these records. Below is an expression, but I know the time format is wrong.
What format do I use?
iif(([AccTime]between 6:01 and 18:00), "Day", "Night")
by default. Through a query I want to build a work shift field for grouping
these records. Below is an expression, but I know the time format is wrong.
What format do I use?
iif(([AccTime]between 6:01 and 18:00), "Day", "Night")