Hi Ed DoitDate is a date field but I also tried DoitStatus which is Text 1, and it will not sort.
Doit is the second table, I am using a DB Grid on the first page of an Enhanced Tab. Maybe that is the problem? Not a major issue just can't figure out what I am missing. Thanks Marc From: Ed Rivkin Sent: Wednesday, October 28, 2009 11:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Arrange By 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, [email protected] 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
