Re: [pilot-db-list] Date calculations (example?)

[<sho...@rc...>]

I have a problem that's simular but less complex:

I want to set up a DB where field 0 is one day after the date in field=20=

0 of the previous record. I've tried to read about inter-record=20
scripts, but it=92s beyond me!


Laura Beryl Gray

On Oct 10, 2005, at 9:30 AM, Samuel F. Montalvo wrote:

> Hi everyone!
>
>  After searching in the mailing archive of PilotDB and reading the=20
> scripts.txt file, I didn't found any example of calculations with the=20=

> current date. This is: difference of days between a date and current.
>
>  I did the following example, but I have some questions related, and I=20=

> hope someone can help me to find the answers.
>
>  [Database]
>  Field0 - Item - String
>  Field1 - When - Date
>  Field2 - Days - Calculated
>
>  [Goal]
>  - To find the number of days since Field1 was set related to the=20
> current date (today)
>
>  [Calculated Field (Theory)]
>  Field2 ->=A0=A0 (dur (- (int gcd)(int %1)))
>
>  [The Problem]
>  (int gcd) always report a "strange" number. For example, for=20
> 10/10/2005 it resolves as 1120971
>
>  But if I create a 3rd field as:=A0 Field3=A0 ->=A0 JustToday - Date
>  and a 4th, as: Field4 -> CalcToday - Calculated
>  and this last as: (int %3), then it resolves as 53529120
>  If I use this combination (with fields 3 and 4), then Field2 resolves=20=

> with the correct number of days since the value in Field1
>
>  [Questions]
>  Is there a way to calculate the number of days as in this example,=20
> without the need to define a 3rd field to store the current date?
>  Why (int gcd) and (int %3) resolves with different values if they are=20=

> the same date?
>
>  Thanks in advance!
>  --
>
> Samuel F. Montalvo
> MComm / TuPalMX
> Guadalajara, Jalisco MEXICO
> Web: http://tupalmx.com=