AnsweredAssumed Answered

Date Calculation

Question asked by thong127 on Aug 8, 2011
Latest reply on Aug 8, 2011 by raybaudi


Date Calculation


Hi Experts..

I Have four (4) fields

Expiry Date (Date)

Retest Date (Date)

Manufacturing Date(Date)

Elapse Date (Calculation)

Kindly help me how to figure out the calculation for the Elapse Date base from the Manufacturing Date when one of the EXPIRY DATE or RETEST DATE is given and i want also that the result of the elapse date should be express in years, Month & Days (0 Years, 0 months, 0 Days).

Thank you very much.