Date issues

[iPirate]

Hi all,

i'm currently trying to build a simple query that shows all records that insurance has expired on. From what i can tell a simple "<=date()" criteria in the expiry date column should cover this and show all dates before and including the current date. However when i run the query i get dates that do not expire until well into 2010, am i missing something simple here or is Access just trying to make me lose my sanity a little more.

Looking forwards to a reply.

Many Thanks
iPirate

P.S. I'm currently using Access 2000 if that makes a difference

 

[namliam]

Is your date column actually a date field or is it a text field?

Go to your table design and double check!

 

[iPirate]

...Well, you were right. Knew it would be something simple. Thanks fella!