[DUG] Sorting by date

[Rohit Gupta]

Yes, the numeral order would be correct.  Or format the date as YYYY-MM-DD

Rohit


On 2/06/2011 10:08 a.m., Charlie wrote:
> Hi, I'm using Delphi 2007 and dBase files. I am creating a .csv file. I
> need to sort my file by RailType and OrderDate. The resultant .csv shows
> RailType is in alpha order and OrderDate is in "string" order; namely,
> the sort is on the month part of the date ( 12/2/2010) that is the 12.
> So I'm getting 1/6/2011 before 12/6/2010. I need to have last year's
> dates appear before this years dates. Hope that makes sense.
> When I'm debugging, if I remember correctly, the date appears as a
> numeral. Would the numeral representation for 12/6/2010 be smaller than
> the numeral for 1/6/2011. If so could I somehow use that for sorting
> (ordering in the query)?
> Thanks so much for your thoughts.
> Charlie