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

Reply via email to