2. ASPRunnerPro General questions
  3. Order data by field
This topic is locked

Order data by field

 		5/27/2004 10:55:21 AM
ASPRunnerPro General questions
U
 Undefined author

I have a database of projects created with AspRunnerPro. The primary list is sorted by each project's DueDate. Everything seemed fine until we enter a date of 10/01/2004, which sorted only on the first digit. As an example, the asending sort order for my DueDate field lists the series such as 10/01/2004, 5/24/2004, 5/28/2003, 6/01/2004, etc. Is there a solution to get a proper sort using more than the first digit only?
Sergey Kornilov admin 5/27/2004

It looks like your date field is treated as a string while sorting data.
Could you tell me what is the data type of DueDate field?
Btw, what database do you use?
U
 		Undefined author 5/27/2004

Sergey:
The database is from Access 2002, SP2. The duedate field in the table design is text. The same field in AspRunnerPro is formatted to be viewed as a short date, edited as a date, and under edit format it is set at simple edit box with datepicker. The default value is FormatDateTime(Now(),2). Would you be implying that I will need to change my Access DB duedate field from text to Date/Time, and set the format on the DB field to Short Date? If so, what else would need to be changed in the field's design?
Thanks.
Sergey Kornilov admin 6/1/2004

I guess you just need to change field type to Date/Time in MS Access and leave the rest of settings unmodified.