viewing records ordered by date

[nitish.dhar]

actually i have inserted the "date" in msaccess database table using "dd-mm-yy" format
now i want to view records of that table in ascending order of the date

so i wrote the query:

Select * from TRANSACTIONS order by aco_date ASC,aco_time ASC";

but the problem is if i write this it compares the day first and then the month and then the year since i have inserted the date in dd-mm-yy
but logically it should compare the year first then the month and then the day...hw can i do that?

[masijade]

By defining the column as a Date column in the DB rather than a varchar column.

A stop-gap solution is to use the to_date SQLFunction on the columns.

[fishtoprecords]

Even if you want to store the string characters rather than as a Date, which is much better in all cases, you don't want to store it as MM-dd-YY or dd-MM-yy for a very simple reason:

you can't do arithmetic or comparisons on it. Store it as YYYYMMDD and then you can do trivial sorting, comparisons, etc.

[nitish.dhar]

Ya i believe u r rite .... thanks for the input