Formatting and sorting date

[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

[Steven Burn]

[url]http://aspfaq.com/show.asp?id=2260[/url]

[url]http://aspfaq.com/show.asp?id=2218[/url]

--

Regards

Steven Burn
Ur I.T. Mate Group
[url]www.it-mate.co.uk[/url]

Keeping it FREE!

Personal favourites

WebGrid - [url]www.webgrid.co.uk[/url]
Freeware Arena - [url]www.freewarearena.com[/url]
Freeware Home - [url]www.freewarehome.com[/url]
Freeware Outpost -
[url]http://free.hostdepartment.com/f/freewareoutpost/index2.html[/url]
ZeroPlus2 - [url]http://zp2.it-mate.co.uk[/url]
Fort Freeware - [url]http://freeware.quantum.2ya.com/[/url]
Pricelessware - [url]http://www.pricelessware.org[/url]
El-Mambo - [url]http://www.el-mambo.net/[/url]
Practically Nerded - [url]http://mvps.org/PracticallyNerded/[/url]
Bugs, Glitches n stuff - [url]http://mvps.org/inetexplorer/Darnit.htm[/url]
Calendar of Updates - [url]http://www.dozleng.com/updates/index.php?&act=calendar[/url]
Seniority - [url]http://www.seniority.co.uk[/url]
Remembering Dunblane - [url]http://www.dunblane.braveheart.com/[/url]
Rising Free - [url]http://www.echoecho.com/[/url]


"S N" <uandme72@yahoo.com> wrote in message
news:eU6K4h5LEHA.644@tk2msftngp13.phx.gbl...

> 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
>
>