Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: Formatting the date via a query?

    Hi,
    I am trying to return a date in the format 'dd/mm/yy', but it is not returning anything when i enter:
    AppList.RowSource = "SELECT Title, Format(Datetime, 'dd/mm/yy') AS newTime, id FROM Appointments WHERE Datetime>NOW() ORDER BY Datetime ASC"

    Now in Access 2000 this worked fine, but i have recently tried it on Access 97 and it is not having it.

    Does anyone have any suggestions? (The default format of my Datetime field is 'dd/mm/yyyy hh:nn')

    Thanks
    Deano

  2. #2
    Join Date
    May 2004
    Posts
    2
    Just to let you know, when i try it through the actual query grid, it comes up '#Error' where the formatted date should be. Thats when: 'newTime: Format(Datetime, 'dd/mm/yy')' is entered

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •