calculating an interval btw 2 dates

[flashbbeb]

Hello,

I am very new to Approach, and have been asked to create a calculated field that shows the interval in years, months, and days between two dates.

So the calc'd field would display "x years, y months, z days".

I don't really know where to start...could anyone help?

Thanks!
EB

 

[karaokek]

I have the same sort of request. Date related.
I have following fields:
Travel date
Passport expiry date

need a warning box if passport expiry date is 6 months or less than the travel date.
(you need 6 months left on your passport when you go abroad on holiday etc)
Thanks