Query and date selection
Well, in the light of a new day it seems to work as you suggested.
I must have been thrown by fixed "2010".
So...thanks, once again.
--
Chrissy
"John W. Vinson" wrote:
On Wed, 12 May 2010 14:46:06 -0700, Chrissy
wrote:
Thanks, John.
I test on the StartDate, future only. So I entered...
Date() And (DateSerial(Year([StartDate]),4,1) Or DateSerial(Year([StartDate]),11,15))
This resulted, like what I was using, current year only.
What do I do about all future dates falling in this range in any future
year?
Thanks,
If you don't reference the year in a date field it assumes the current year,
so #11/15# will be 11/15/2010 if you run the query today, 11/15/2011 if you
run it next year.
My suggestion WILL WORK, if you try it. It will work this year, it will work
next year, it will work in any year.
--
John W. Vinson [MVP]
.
|