Using "like" when searching dates

[rickp101]

I am having trouble searching for dates by their year. The dates are in date format and I need to select all results with a specific year in the date i.e. any with 2001. I have tried - WHERE date like '*2001' and many alternatives such as #*2001# etc but to no avail. Anyone help?
thanks

Rich

 

[Maquis]

Add another field to your query called:

Year: Datepart([yourdatefield],"yyyy&quot

And then put your year in this field's criteria section.

 

[Databaseguy]

Where right([YourDateField],4) = "2001"

 

[tlbroadbent]

Or try...

Where Year([DateField])=2001 Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.