How to set criteria for date field in query wizard for record

[kassem]

Hi, i have a field called DateOfEstimate and i want the records to show one buisness day before Tomorows date. For Example if tomorow is sep 2. The result for all the records that have a DateOfEstimate on sep 1 will show. If Sep2 if on the monday however, the result should show on the friday because i go by buisness days. Can someone help me figure out what to write in the criteria field.

I wrote

date()+1

but this dosent handle the buisness days condition.

[June7]

Not sure I understand - "one business day before Tomorrows date" - isn't that Today?

Don't you want to subtract not add days?

Could DateOfEstimate ever be a Saturday or Sunday?

Try:

DateOfEstimate - Nz(Choose(Weekday(DateOfEstimate,vbSaturday),1,2,3 ),1)

Do you have to consider holidays?

[behnam]

I figured most of it out, Just stuck on one part.

IIf(..,Date()+4,Date()+1)

to finish the iff statement you need to somehow specify in the .... location if the Date is on a monday. Do you have any idea how to do that?