ORDER BY Date inc. year

[oliverreade]

Hi all,

For example when using the ORDER BY date statement. The results come back in day order only.

An example of the date format I am using is:

dd/mm/yy

02/12/06

will come before 01/03/07.

Any help will be appreciated.

 

[Cleggy]

order by year(date_field) desc;

 

[bdmclennan]

Try this

order by format([date],"YYYYMMDD&quot desc

Cheers

 

[cmmrfrds]

Your date must be in a "text" data type or it would order correctly.

Try converting the text field to a date field and then ordering. I believe CDate will convert if it is in a valid date format in the text field. That is the simpliest if it will work ie. text field has a valid date format.

Order by CDate(yourtextdate)

 

[MichaelRed]

cmmrfrds yes.

others. read cmmrfrds

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over