First Business Day of Month Macro Condition

[Smilie]

I need to run a report via macro that runs once a month on the first business day of the month. I can't figure out how to specify that condition.

Seems simple, but I just can't think of the solution.

Any ideas?

thanks in advance.

 

[databasedonr]

Not sure if there is a better way, but this might get you started: you can use format on the date field to determine the day and the date.

Where dtDate is a date Field,
Format([dtDate], "dddd") returns the actual day, ex. "Friday"
Format([dtDate], "d") returns the date, ex. "24"

you'd still have to work out the logic to have your particular code execute, but maybe this will help you identify when to run it.