Don
On 8/1/06, Ralph Alvy <
[EMAIL PROTECTED]> wrote:
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
--
Don Friedman
ProfessionalRecords.Com LLC
PRS Data Systems
205 S Main Street
Pittsburgh, PA 15215
412-784-1600 - 1-800-PRS-FILE
412-784-1615 Fax
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
