I have this iff statement in a table that is working for what I needed it to do, I need some help modifying it.
There is a field name in that table named "Time On" I need the formula to read,Code:IIf([shift]=3,[date]-1,[date])
ThanksCode:IIf([shift]=3 and Time On is between 00:01am and 06:00am ,[date]-1,[date])