By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,161 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

Access 2003 Query Date Functions

P: 1
When using the expressions
Date()-1
and
[Date Completed]-[Date Received]
is there anyway I could get them to not count weekends?
Date()-1 works well until I need it to show Fridays totals on Monday.
[Date Completed]-[Date Received] I have to manually subtract if there is a
weekend involved.
Unfortunately I inherited this database and I can't make a new table for dates so I was hoping I could come up with something to help.
Feb 14 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
There is a parameter in the DateAdd() and DateDiff() functions that (should) work with weekdays. I've had problems with it in the past though and find it unreliable.
Check out (Function to Move (Forwards or Backwards) Through Weekdays) for a function that may be of use.
Feb 14 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.