«

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

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

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

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Personal favourites

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


"S N" <> wrote in message
news:...
> 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
>
>