|
| 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
October 19th, 2004, 02:42 PM
|
|||
|
|||
Year to Date Date Restrictor
Hello,
Can someone tell me how to do a date restrictor for year to date that would not be just "between 1/1/04 and 12/31/04"? Also, is there a web site that lists different types of date restrictors? Thanks, Haji 
|
|
#2
October 19th, 2004, 02:54 PM
|
|||
|
|||
|
You tell us what you DON'T want it to be, but don't explain what you DO want
it to be. Year-To-Date (in my mind) is January 1st through TODAY. I'd use... Between #01/01/04# and Date() Rick B "Haji" wrote in message ... Hello, Can someone tell me how to do a date restrictor for year to date that would not be just "between 1/1/04 and 12/31/04"? Also, is there a web site that lists different types of date restrictors? Thanks, Haji
|
|
#3
October 19th, 2004, 07:10 PM
|
|||
|
|||
|
Or perhaps the following if you are looking for everything in the current year.
Between DateSerial(Year(Date()),1,1) And Date() Rick B wrote: You tell us what you DON'T want it to be, but don't explain what you DO want it to be. Year-To-Date (in my mind) is January 1st through TODAY. I'd use... Between #01/01/04# and Date() Rick B "Haji" wrote in message ... Hello, Can someone tell me how to do a date restrictor for year to date that would not be just "between 1/1/04 and 12/31/04"? Also, is there a web site that lists different types of date restrictors? Thanks, Haji
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| QDE (Quick Date Entry) | Norman Harker | Worksheet Functions | 37 | September 5th, 2004 01:24 AM |
| Year to Date | Alex | Running & Setting Up Queries | 3 | July 21st, 2004 05:20 PM |
| Problem with Date Restrictor on Form | Chuck W | Running & Setting Up Queries | 3 | June 10th, 2004 10:47 PM |
| Finding a date from year, week of the year (1-52) and day of the week (1-7) | Bob Phillips | Worksheet Functions | 6 | January 28th, 2004 04:21 PM |
Linear Mode
