Try a query like this:
SELECT *
FROM Reservations
WHERE StartDate DATE()
AND FORMAT(StartDate, "mmdd")
NOT BETWEEN "0401" AND "1114";
This works by excluding future dates outside the range rather than including
those within it.
Ken Sheridan
Stafford, England
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,
I test to see if a reservation begins between 11/15-3/31 of any year.
[quoted text clipped - 16 lines]
DateSerial(Year(Date()), Month([reservationdate]), Day([reservationdate]))
BETWEEN #1/1# AND #3/31#;
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1