[RBASE-L] - Re: Arrange By

[Ed Rivkin]

Marc, My experience sorting dates is from R:Base 4.0 days. I never liked the way it sorted dates so I created a calculated field in my tables so I can sort dates consistently. I am assuming that "doitdate" in your example is a date field. Here's what I use to sort the field Duedate ((iday(duedate))+((imon(duedate))*32)+((iyr(duedate))*400)-730000) It may seem a bit crude in today's world but I frequently use multi-table forms and the rows with Duedate are presented as desired by sorting on this calculated Duedate rather than Duedate itself. Ed Oct 28, 2009 08:44:27 AM, rbase-l@rbase.com wrote: Hi all   What am I doing wrong?  I am using the latest 7.6 build but can't get the second table's DB Grid to sort using   EDIT USING mainmenu ARRANGE doit BY doitdate  Asc   Thanks Marc