Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calculating an interval btw 2 dates

Status
Not open for further replies.

flashbbeb

MIS
Mar 29, 2005
106
US
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top