Append Query Previous Working Day

[joeserrone]

Hello Everyone,
I'm using an append query to feed a table with raw data. In the Table I am also collecting the Working Day which is always the Previous Working Day from the Date I am running the Append Query. So for 10/09 I need to have all records append with the Work of Date of 10/08.
In the field I have Date()-1 which works ok during the week but on Monday it is appending records with a Date of Sunday. Is there a formula I can use where Access will know that I intend working days (Monday through Friday) so data appended on Monday will have Friday's Date?

Thanks

 

[dbDamo]

I saw a thread with a workday module on here just a few days ago, try searching the site for it and it should be what you're after

 

[HiTechCoach]

Sure. I use this code:

fAddWorkDays
note: Put all the code into a code module.


Usng the code above, you could use:

fAddWorkdays(Date(), -1)

Hope this helps ...