[AccessD] ORDER BY BUG using Date format AARHG

Hi Sander

Your "stupid" test is correct as it sorts DESC on a string.

Try this which I think is what Bert-Jan has in mind:

  SELECT DISTINCT
    Format([TblArbo].[Datum], "dd-mmm-yyyy")
  FROM
    TblArbo
  ORDER BY
    [TblArbo].[Datum] DESC;

/gustav


> I've got a combobox based on a query:
> SELECT DISTINCT [TblArbo].[Datum]
> FROM TblArbo
> ORDER BY [TblArbo].[Datum] DESC;
> Resulted in:
> 01-10-2003
> 02-09-2003
> 21-08-2001
 
> The user asked if this could be printed in the following format: dd-mmm-yyyy
> No problem, says stupid me:
> SELECT DISTINCT Format([TblArbo].[Datum],"dd-mmm-yyyy")
> FROM TblArbo
> ORDER BY Format([TblArbo].[Datum],"dd-mmm-yyyy") DESC;
 
> But now the ORDER BY ONLY checks the DD part?!?!?!?!
> So this results in:
> 21-08-2001

> 02-09-2003
> 01-10-2003
> ?!!??! What kind of nonsense is this?