IIf statement

[clueless]

My IIf statement is as follows:

StatusOfAppointment: IIf([ArrivalTime]<[AppointmentTime],"Early",
IIf([ArrivalTime]=[AppointmentTime],"On Time","Late))

I need to add a 15 minute window for the "On Time" (example appt 3:00, would
be on time from 3:00-3:15). Not quite sure what I need to do. Appreciate
any help.
Thanks.

 

[Beetle]

It should be something along the lines of;

StatusOfAppointment: IIf([ArrivalTime]<[AppointmentTime],"Early",
IIf(DateDiff("n",[ArrivalTime],[AppointmentTime])<=15,"On Time","Late))

 

[fredg]

My IIf statement is as follows:

StatusOfAppointment: IIf([ArrivalTime]<[AppointmentTime],"Early",
IIf([ArrivalTime]=[AppointmentTime],"On Time","Late))

I need to add a 15 minute window for the "On Time" (example appt 3:00, would
be on time from 3:00-3:15). Not quite sure what I need to do. Appreciate
any help.
Thanks.

So is that 3:00 AM or 3:00 PM?
Is it considered on time if the Arrival time for an Appointment for
3:00 PM is actually 3:10 AM the next morning? That would meet your
criteria.

You're also missing an ending quote after the word Late in your
expression.

StatusOfAppointment:IIf([ArrivalTime]<[AppointmentTime],"Early",
IIf([ArrivalTime] Between [AppointmentTime] and
DateAdd("n",15,[AppointmentTime]),"On Time","Late"))

 

[Klatuu]

Iif([ArrivalTime] < [AppointmentTime],"Early",iif([ArrivalTime] <=
dateadd("n",15,[AppointmentTime]),"On Time","Late"))