|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 14th, 2007, 02:38 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Date expressions that can exclude weekends
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. 
|
|
#2
February 14th, 2007, 04:29 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Date expressions that can exclude weekends
On Feb 14, 2:38 pm, Michelle
wrote: When using the expressions Date()-1 and [Date Completed]-[Date Received] is there anyway I could get them to not count weekends? See: Why should I consider using an auxiliary calendar table? http://www.aspfaq.com/show.asp?id=2519 "A calendar table can make it much easier to develop solutions around any business model which involves dates. Last I checked, this encompasses pretty much any business model you can think of, to some degree. Constant problems that end up requiring verbose, complicated and inefficient methods include the following questions: How many business days between x and y? ... As you can imagine, all of these answers require complex iterative code that steps through and applies logic to each of the dates in a range. Or do they...? " Jamie. --
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
