iif expression and time format

  • Thread starter Thread starter TDC
  • Start date Start date
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")
 
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.
 
Back
Top