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
|
|||
|
|||
Date restrictor for this week
Hi,
I want to create a report that will always give sales for the current week starting with monday and going to friday. We are closed on Saturday and Sunday but if a sales manager runs a report on friday or saturday, it would give him sales for this week. Thanks, -- Chuck W |
#2
|
|||
|
|||
On Tue, 20 Sep 2005 08:26:32 -0700, ChuckW wrote:
Hi, I want to create a report that will always give sales for the current week starting with monday and going to friday. We are closed on Saturday and Sunday but if a sales manager runs a report on friday or saturday, it would give him sales for this week. Thanks, You can use Access' builtin date functions to do this. A criterion of = DateAdd("d", -DatePart("w", Date()), Date()) AND DateAdd("d", 8-DatePart("w", Date()), Date()) will get from the previous Sunday through next Sunday. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Convert week # into date of the first day of week in SQL | Access Tom | Setting Up & Running Reports | 15 | October 21st, 2004 10:01 PM |
QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |
Does date fall between two ranges? | MR | Worksheet Functions | 4 | January 14th, 2004 04:08 PM |
Returning a date based on weeknumber | Jesper | Worksheet Functions | 10 | December 21st, 2003 04:25 PM |
Excel expression that would always show the Sunday date of the current week | Rudy | Worksheet Functions | 1 | September 18th, 2003 12:51 AM |