Dates not sorting properly 1

[crisis2007]

I have a listbox that contains dates from a table. I have the dates listed in descending order but for some reason, it believes that 01/01/2012 should be listed below 12/31/2011. I have MS Access 2003 if that is needed. Any suggestions?

 

[dhookom]

You really need to provide the SQL of the Row Source of the list box. It's fairly easy to sort your Row Source by the date descending and much more difficult to sort by a formatted date.

SELECT MyDateField
FROM MyTable
ORDER BY MyDateField DESC;

Duane
Hook'D on Access
MS Access MVP

 

[missinglinq]

Also, in the underlying Table, is the Field actually defined as a Date/Time Datatype or as Text?

Linq ;0)>

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[SkipVought]

for some reason, it believes that 01/01/2012 should be listed below 12/31/2011.

Hmmmm?

Does not 12/31/2011 occur one day BEFORE 01/01/2012?

Conversely, does not 01/01/2012 occur on day AFTER 12/31/2011?

I do not understand your conundrum?


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[crisis2007]

Sorry, I should have posted more information. But Missinglinq's question had me looking back at my table and yes, once again I overlooked the error of setting the field as text rather than date. Thank you!

 

[missinglinq]

Glad we could help1

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!