Dates Without Years

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I would like to query a column with dates in it to get a
range, but I do not want the use to have to enter a year,
since the year is irrelevant and it should pull from all
years.

This is what I tried to use:

Between (Like [Start] & "*") And (Like [end] & "*")

also

Between (Like [Start] & "/" & "????") And (Like [end]
& "/" & "????")

These don't work, any other ideas??? Thanks!
 
Michael,

It is not clear from your posting whether your criteria will be applied to a
single date field or to two date fields. However, if you want to search on
a range of months disregarding year, you could use the Month() function.
 
Back
Top