iif expression and time format

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")
 
M

Marshall Barton

TDC said:
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")
Click to expand...


This was asnswered in another forum where you posted the
same question.

Posting the same question multiple times wastes everyone's
time. If you feel compelled to post to more than one forum,
at least cross post it by posting it to both forums in a
single post.
 
Top