Iff statement help

[jcaptchaos2]

I have this code that moves the 3rd shift start date ahead 1 day because they start at 10pm the previous date, I need to add to it so if they transact on between midnight and 7am it doesn't move the date ahead. The column name for the time is [Time On] any ideas?

IIf([shift]=3,[date]+1,[date])

thanks

JC

 

[Dartagnan]

Believe this will work.
IIf([shift]=3 and [time on] between {1st parameter} and {2nd parameter},[date]+1,[date])

 

[jcaptchaos2]

Thanks for the advice Dartagnan