Ordering Problem with Months

This topic is locked

Ordering Problem with Months	8/28/2003 12:19:46 PM
ASPRunnerPro General questions
swat author I have the DB sorted my month my sql code : "... I am gettin my DB sorted by month first but it sorting the months alfabetical order. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=168&image=1&table=forumtopics' class='bbc_emoticon' alt=':huh:' /> .like april/desc/..... not the original mothn order.? Any ideas. Thx swat


	Sergey Kornilov admin 9/3/2003
	Hi, you need to store month number somewhere to order data by month. Text fields are always being sorted alphabetically. Best regards, Sergey Kornilov