S
S N
I have an asp page which displays records from an access table.
One of the fields in the table is a date field.
The regional settings on the webserver have set the date as mm/dd/yyyy which
I cannot change. However I need to sort the records in order of date in
dd/mm/yyyy format. the date field should also be displayed in dd/mm/yyyy
format. However the SQL string which says sorting by date field actually
sorts it in the order of month instead of date. it subsequently prints the
date in dd/mm/yyyy format but in wrong order.
Please help
One of the fields in the table is a date field.
The regional settings on the webserver have set the date as mm/dd/yyyy which
I cannot change. However I need to sort the records in order of date in
dd/mm/yyyy format. the date field should also be displayed in dd/mm/yyyy
format. However the SQL string which says sorting by date field actually
sorts it in the order of month instead of date. it subsequently prints the
date in dd/mm/yyyy format but in wrong order.
Please help