Date Data Type & Query Question

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a field in a table in which I want to store the month and day only
(e.g. 1/3, 3/1, 4/15, 11/15, etc.); the year is not needed. I also want to
be able to run a query on this field which will select records between a
beginning and ending month/day such as between 1/1 and 3/1.

What field data type should I use? I started out with date/time which
worked fine until the current year changed from 2003 to 2004. Changing to
text data type appears to work okay, except then I don't know how to
properly set up my query to select records between my beginning and ending
month/day choices. (10/15 and 11/15 are considered to be between 1/1 and
1/3 when data type is text).

Thanks in advance for any help.

Bob
 
I suggest you leave your table with date/time data type. In addition to that you will need to create a query that will format your date/time field into "mm/dd" using standard formatting functions and will reuse existing date/time field. Use this query for your task. This way you will have flexibility in selecting filter to apply. Hope that helps
 
Back
Top