if statement with date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a date/time field "EnterDateTime" 11/2/2005 3:38:00 AM

i'm wanting to use the expression

Shift:
IIf([EnterDateTime]>7,IIf([EnterDateTime]>15,IIf([EnterDateTime]>23,"Night","Evening"),"Day"),"Night")

i need to extract on the hour "3"

how do i put this into my IIf statement?
 
IIf(Hour([EnterDateTime])>7,IIf(Hour([EnterDateTime])>15,IIf(Hour([EnterDateTime])>23,"Night","Evening"),"Day"),"Night")
 
Back
Top