Season dates query

[Mike Green]

Hi Guys
I have a requirement to select dates within a season. The seasons are linked
to different wildlife in the Db. The season for different animals runs
from a specific date to a specific date which is the same every year.
How can I represent this in a query so that I can get back all the dates
within the required season for a specific animal type for all years in the
Db?
I have started with a table for the animal type with a season start date and
a season end date but Access wants to add a year to the date which is one of
the paramiters that I do not want as I need every year!
Anyone come across this sort of thing before and could give me some
guidance?
It will be much appreciated.

Regards

Mike

 

[Guest]

Dates always store dates. If you want just a month and day then use a date
but ignore the year in any calculation. You could also use two fields, one
for month and one for day.

 

[Douglas J. Steele]

The Date data type is only capable of holding complete dates. A month and
day alone is not a complete date, therefore a Date data type cannot hold it.

Consider storing the month and day as two separate fields. You can always
convert them to a date in the current year using DateSerial(Year(Date),
StartMonth, StartDay) as a calculated field in a query.