Year to Date Date Restrictor

H

Haji

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
 
R

Rick B

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
 
J

John Spencer (MVP)

Or perhaps the following if you are looking for everything in the current year.

Between DateSerial(Year(Date()),1,1) And Date()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Year to Date date restrictor 2
Date restricter for current quarter 1
Date Restrictor for this month 1
Date restrictor for the current year. 2
Date Restrictor for this week 7
Date Restrictor no longer works when linking to SQL Server table 5
Date Restrictor for Last Week 4
Last Months Sales Date Restrictor 2

Top