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 _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe