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