order results by date not working

bla4free · #1 (**permalink**) 10-03-06, 11:28

hi. i'm trying to order my results ascending by date except i'm getting some really weird output. my ouput resembles something like this:

oct 2
oct 3
sep 13
sep 21
sep 22
sep 30
aug 3
aug 5
aug 16

the data is stored in a date field. i use getdate when inserting the date to the database. is there a reason why the dates are showing up weird and not ordering appropriately? thanks for your help.

also, can you not search here any more? i keep getting timeout errors.

blindman · #2 (**permalink**) 10-03-06, 12:41

Can you post the code you are using?

bla4free · #3 (**permalink**) 10-03-06, 13:03

Code:

SELECT Documents.MergeID, Documents.VBKey, Documents.DocumentID, 
Documents.DateCreated, Documents.[FileName] AS FileNameDesc, 
DocumentDescription.[Description] AS DocumentDesc FROM Documents 
LEFT JOIN DocumentDescription ON Documents.DocumentID=DocumentDescription.DocumentID 
WHERE Documents.VBkey="& vbkey &" AND Documents.DateDeleted IS NULL 
ORDER BY Documents.DateCreated DESC

shammat · #4 (**permalink**) 10-03-06, 14:04

Could it be that the dates hav different years in them? You could output the full date to verify that

bla4free · #5 (**permalink**) 10-03-06, 14:11

Quote:

Originally Posted by shammat

Could it be that the dates hav different years in them? You could output the full date to verify that

no, the correct years are in there. the only year in there would be 2006 for right now b/c that's when this project got started. thanks for your help though!

bla4free · #6 (**permalink**) 10-03-06, 14:18

ok. i just ran this through query analyzer and this is how it's displaying the dates:
Sep 26 2006 3:10PM

so, it looks like my dates are being arranged alphabetically???