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?
thanksCode:IIf([shift]=3,[date]+1,[date])
JC