[AccessD] ORDER BY BUG using Date format AARHG

Bert-Jan Brinkhuis thevigil at kabelfoon.nl
Fri Apr 2 01:39:06 CST 2004


Hi Sander,

i do not know what kind of nonsense that is, but i have a workaround for
you.

Add the original unformated [datum] field to your query and order on that
field.
Make sure you do not display that column in the combobox!

HTH

Bert-Jan

----- Original Message ----- 
From: "S D" <accessd667 at yahoo.com>
To: "accessd" <accessd at databaseadvisors.com>
Sent: Friday, April 02, 2004 9:06 AM
Subject: [AccessD] ORDER BY BUG using Date format AARHG


> Hi group,
>
> 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?
>
> Sander
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Small Business $15K Web Design Giveaway - Enter today
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com




More information about the AccessD mailing list