Sorting on text dates

[victorab]

How can I force Access to interpret the date (e.g.) 12/01/29 to mean 12/01/1929, instead of 12/01/2029? And how can I sort correctly on a text date with the two digit year format?

 

[victorab]

Thanks for the tips, Pat. Reason I am using a text field for the dates in my application is that the application imports records from another system which uses dates in mm/dd/yy format. The users are so used to using this format that they expect to type only yy as the year when they use the date field (birth date) to do a search. If I use a date field, Access automatically converts the date 12/01/29 to 12/29/2029, instead of 12/29/1929, when it imports the records.