Dayshift/Nightshift field based on time of day

A

akraw

Joined
Mar 25, 2011
Messages
1
Reaction score
0
Greetings All,

I have been trying to create a field that will display "DAYSHIFT" before noon and "NIGHTSHIFT" after. This is rather difficult, since I can't find anywhere an explanation of how Word parses date/time values. To get around that, I have tried the two following field codes:

{If Time \@"HH" < 12 "Dayshift" "Nightshift"}
{If Time \@"am/pm" = am "Dayshift" "Nightshift"}

Both of these yield the result "NIGHTSHIFT" now, and also when I switch the system time to AM.

Can someone please tell me what I'm doing wrong?

thanks.

ak
 

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

Multiple averages in large continous data field 2
Macros/VBA to fill time card 3
Last Rec or New Record 7
Changing constants in a query to user input values 2
To Ken Snell 2
Excel Excel IF variable based on time of day 0
how to avoid clicking toggle field code each time to view result 5
Conditional Sumproduct() Based on the Time of the Day 3

Top