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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |