DateAdd Error

[TimMoffy]

i have searched high and low for an answer to this but dont always understand some of the answers i am seeing, espeically as everything leads me to believe that I have got my syntax spot on.
We have a field on a form that needs to display a date five working days after todays date to ensure compliance with our regualator.

The code i have put in is for the form this is located on is



OnLoad
Me.dtm5DayDate = DateAdd("w", 6, [dtmDateReceived])

But everytime we use this it adds 6 days in total to the date, not just working days. So for today, 17th April it dispalys the 23rd April,because it is counting the Saturday and Sunday as well.
Any great ideas?
Thanks as always

[Rawb]

Are you wanting to include things like holidays (where the non-working day can appear in the middle of a week) or is it good enough that you always add one full week?

If you don't care about the holidays, then you can just add +1 week (all 7 days) to the date and be done with it:

Me!tdm5DayDate = DateAdd("ww", 1, [dtmDateRecieved])

[TimMoffy]

Of course 5 working days will always be the same day the following week. You're right i dont care about holidays.
Thanks