Re: [Dataperf] Using date to Reverse Index.

Tue, 01 Aug 2006 15:59:04 -0700

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.
 
Bye
Brian
 
 
 
 
----- Original Message -----
Sent: Wednesday, August 02, 2006 8:31 AM
Subject: [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

Reply via email to