I am trying to write a script that will calculate the difference between a date enter into a date field and the current date then return the result as a text string (Xyrs Xmos). I cannot get the month part to calculate correctly because the months do not occur in the same year always.

Example:

9-1-03 comparison date

11-1-04 current date

1yrs 2mos desired result

1-1-04 comparison date

11-1-04 current date

0yrs 10mos desired result

I am new to scripting in filemaker but not to scripting in general but have never work with dates before.

Any help is greatly appreciated.

-REM

Unstored calculation field:

Let ( [ diff = second_date - first_date ] ;

( Month(diff) - 1) & " mos " & Day(diff) & " days " & (Year(diff) -1 ) & " yrs"

)

Thank you that is prefect. Is there a good reference for scripting?

For intermediate level programming, see Learn FileMaker 7. For advanced programming, see Using FileMaker 7.