Hello Ralph. The incremental jump in values are weird but I'm not sure hot it calculates. I have to look at it more closely. In any case, it seems to be working.
Thanks for your help and Brian's and Don's too. Ed. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ralph Alvy Sent: Tuesday, August 01, 2006 4:36 PM To: DataPerfect Users Discussion Group Subject: Re: [Dataperf] Using date to Reverse Index. On Tue, 01 Aug 2006 15:31:14 -0700, E. Marfil, MAST UNITED <[EMAIL PROTECTED]> wrote: > I need a panel to open at the last record entered using the date/time > fields. I know how to reverse index using a negative numeric field but > how > do I make a "negative" date field? If P1F1 is your Date field and P1F2 is your Time field, create an index using this 10-digit field as its primary key: Format: G9999999999 Formula to update on any change: 9999999999 - P1F1*86400 - P1F2 That should do it. _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
