Revise dates query

[GOVMATE]

Can some help me with a query in access 2003 that looks at dates in this format example: 10/22/2007 and changes them to 10/22/07.

Thanks a million in advance!!!!

 

[GOVMATE]

Assuming your dates are real date/time data types then:

Format(YourDate,"mm/dd/yy")

I appreciate your quick reply Pat. I should have been more detailed. My dates are not real date/time data. I have numerous records with various dates from 2004 -2007 and all are in the format MM/DD/YYYY in which I need a query that will change them all to this format MM/DD/YY

 

[Jon K]

If day and month are not always two digits-

Left([YourDate],InStrRev([YourDate],"/")) & Right([YourDate],2)
.