Formatting and sorting date

Discussion in 'ASP General' started by S N, May 1, 2004.

  1. S N

    S N Guest

    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
    S N, May 1, 2004
    #1
    1. Advertising

  2. S N

    Steven Burn Guest

    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/freewareoutpost/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
    >
    >
    Steven Burn, May 1, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Matt
    Replies:
    1
    Views:
    570
    Matthew Speed
    Nov 8, 2003
  2. Peter Grison

    Date, date date date....

    Peter Grison, May 28, 2004, in forum: Java
    Replies:
    10
    Views:
    3,193
    Michael Borgwardt
    May 30, 2004
  3. Matt
    Replies:
    2
    Views:
    493
    Pete Becker
    Nov 8, 2003
  4. Matt
    Replies:
    3
    Views:
    694
    Richard Heathfield
    Nov 8, 2003
  5. Matt
    Replies:
    11
    Views:
    390
    Aaron Bertrand [MVP]
    Nov 8, 2003
Loading...

Share This Page