Check what kind of field you're using.
Don
On 8/1/06, Brian Hancock <[EMAIL PROTECTED]
> wrote:
Hi Edwin,In reality a date field is just a number field, with each number being the ordinal day since a particular start point (I can't exactly remember, but unless you are using old dates it doesn't particularly matter)... Therefore you can take dates and perform mathematical operations on them, such as subtracting them to get the days difference... Since you can also manipulate the date as though it was an ordinary number so you can do something like this (99999 - [date]) or (-1 * [date]) or anything similar to invert the value... For an index it doesn't matter if the result doesn't make common sense, as its prime function is to set the order, although if you want to create Virtual subreports, or Skip to RV using that part of the index then you will need to apply the same transformation to whatever you are linking or skipping to.ByeBrian----- Original Message -----From: E. Marfil, MAST UNITEDSent: Wednesday, August 02, 2006 8:31 AMSubject: [Dataperf] Using date to Reverse Index.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
_______________________________________________
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
