Thread: Date convention
View Single Post
  #10  
Old 22nd August 2005, 16:28
Andy Fletcher's Avatar
Andy Fletcher Andy Fletcher is offline
Senior Member
 
Join Date: Dec 2004
Location: Cork, Ireland
Posts: 776
Andy Fletcher
Re: Date convention

Like Jim P I have never had any problem sorting dates with access provided they are entered as dates (the data field set to date) and not entered as plain text which does create problems when filtering and sorting.

Also when the date is entered as a date (and not a text string) then you can adjust the date format to whatever you like and it automatically updates the format of every date in the field.

Regards

Andy Fletcher
Reply With Quote