|
By the way, is it possible to incorporate
into one field both date and time? Thanks. Ed. From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Friedman Ed - I'm curious as to
what part "doesn't compute". I just went into a blank panel and
created a standard date field D99/99/9999 and another field G-99999999. Then I
entered today's date in the date field and in the other field got -00039234.
Tomorrow would be -00039235. 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. Bye Brian ----- Original Message ----- From: E. Marfil, MAST UNITED 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
