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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iif statement and time format 2
Access Building a IIF expression in Access 0
Determine if night shift by start & end time 2
Pivot table macro filter data between yesterday and today (date+time) 0
Time Isue again 5
Peculiar default cell format 1
separating date and time 5
IIf statement with Between 5

Top