Expression in query to calculate a date that skips over weekends and holidays

[ui7598h]

Hello,

I have a query that calculates a date base on a trailer receive time. I currently have it set to where if the receive time is prior to noon, it returns the current date. if after noon, it returns the next day's date. expression is SysRecDate: IIf([tbl_TrailerQueue]![ReceiveTime]<0.5,[tbl_TrailerQueue]![ReceiveDate],[tbl_TrailerQueue]![ReceiveDate]+1)

I need it to skip over weekends and holidays though. In excel it would look like =if(C2<.5,D2,WORKDAY(D2,1,H2:H6)) where C2 is the Time, D2 is the date and H2:H6 are the dates of Holidays.

Any help would be great.

Steve

[June7]

This is a common topic. Search forum or web. Here is one https://www.accessforums.net/queries...ays-51341.html