Access dates

[griffitd]

I am trying to do a DELETE SQL statement to delete records where a date is less than 30 days from the current date.

The PC is running windows 2000 with the default and current regional settings set to UK.

If I enter a date of 04/13/2003 all records where the date is less than 13/04/2003 are deleted. If I enter the above date into the datasheet access automatically changes the date to 13/04/2003. I think is why the sql query i am writing is still deleting the data. Any suggestions?

 

[dumdum]

? I'm a little lost here on what you mean. Could you post the query you're using? Thanks. We are always looking for new members at our computer forums:

http://forums.jlrforum.net