Season dates query

M

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
 
D

Duane Hookom

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.
 
D

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.
 

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

Top