Year to Date Date Restrictor

  • Thread starter Thread starter Haji
  • Start date Start date
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
 
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
 
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

Back
Top