Randy-
Well, if you can ignore holidays, 20 business days is exactly 4 weeks. You can
add an integer value to any Date/Time value to add days, so:
Result: CDate([WarrantyDate] + 28)
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of rmrodgersar
Sent: Sunday, September 25, 2011 10:08 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Help with a date expression
I am attempting to run a querie in my warranty database and need a little help.
Im a bit new to using assess 2007.
I need to run a querie that will give me the results of 20 busniess days from a
specific date.
What expression would i use.
Example: If i receive a warranty on 9/5/2011 the due date would be 20 business
days later (9/30/2011). How can i have access exclude the weekend days.
Thank you,
Randy Rodgers
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar