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