Hi Edwin,
 
Remember that if you multiply it by -1 then you need to ensure the target field allows negative values eg G-ZZZZ9
 
If it is a date, then you will be able to do mathmatical computations, there is just something else wrong...
 
Brian
----- Original Message -----
Sent: Wednesday, August 02, 2006 8:57 AM
Subject: RE: [Dataperf] Using date to Reverse Index.

Hi Don.

 

I tried it but it doesn’t compute.  Only other thing I can think of is a negative numeric field using the auto-increment but I’m trying to avoid auto-increments.  Any other idea?

 

Thanks.

 

Ed.

 

 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Friedman
Sent: Tuesday, August 01, 2006 3:45 PM
To: DataPerfect Users Discussion Group
Subject: Re: [Dataperf] Using date to Reverse Index.

 

Eric - if I remember correctly a date is simply a numeric value. Multiply it by a negative 1 and you'll have what you're looking for.

Don Friedman
Pittsburgh

On 8/1/06, 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?

 

Thanks for any suggestions.

 

Edwin


_______________________________________________
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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf

Reply via email to