Problem with DateAdd function

[Guest]

I currently have a calculated control using the data source:

DateAdd("w",1+[EstDays],[dtFileReceived])

My problem is that the calculated field continues to include the weekends in
it's calculations. Any ideas?

Thanks,
Lance

 

[Douglas J Steele]

Take a look in the Date/Time section of the "The Access Web"
http://www.mvps.org/access/

There are a couple of solutions there.

Alternatively, take a look at what I wrote in my September, 2004 "Access
Answers" column in Pinnacle Publication's "Smart Access". You can download
the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html