Filtering Dates

[Big X]

Hi,

I am having a little trouble with some data I have been sent. Seems they want me to remove all the date that have a 5 year expiry date. I receive the data in csv file so the properties of the fields I can set in access to text or date which ever is needed. Atm I ran a sql query not like "*2013" which give me every thing before that year. I was wondering in the criteria box in access in expiry date field how to do this. I would like to be able to go < 01/06/2013 or greater than to seperate the records. I have tried and it seemed to work at first for > "01/01/2013" but for less than I got no results. Later I when I went to dabble some more I could get either to work. Any time on filtering dates would be great thank you.

[Big X]

Got it,

I set my field value to Date and used # # to surrond the date ie

< #01/01/2008#

I hate it when I find a solution 5 minutes after jumping on here ;)

[NeoPa]

Good for you Big X :)

For anyone interested in a more detailed breakdown of using dates in SQL try Literal DateTimes and Their Delimiters (#).