Re: [pilot-db-list] Calculated Fields

[Scott W. <swa...@my...>]

I can't comment on your first problem because it seems that it might have 
to do with the conversion from csv to pdb format, and I'm not too familiar 
with db-tools.  As for your problem with 'gcd', are you sure that your 
palm's clock is set correctly? I debug regularly with the Vx, and I have 
not seen any strange behavior with gcd.  Perhaps it would help if you sent 
me the script.  

	As for doing calculating differences between dates, you can use 
the 'dur' operation to cast an integer as a duration.  So if %1 and %2 are 
dates (dur (- (int %1) (int %2))) will give the difference between these 
dates in days, hours and minutes.  However, getting the difference in 
days, months, years is not possible, but it is a good idea.


	-Scott

> 2. The 'gcd' function returns the value of today's date with the year as
> '1999'.
>  
> While transferring the data the '.ifo' file contains the following
> command -
>  
> format date %d/%m/%Y
>  
> What's wrong??
>  
> Further, is there any simple way of doing date calculations viz.
> difference between two dates in years, months and days etc.
>  
> Kapoor
> dh...@si...
>  
> 

--