Subtracting dates and representing in other formats and figures

[#1]

Hello,

Find attached. I explained in details in attach.

[Anonymous]

I guess your problem is with the date format in QVD.  It doesn't fit the declared date format.  If leave it as is, the expression for the retirement date (I understand it is the earliest between 60years old and 35 years of service) is:

is:
=date(rangemin(
AddYears(date(date#([Employment date],'DD.MM.YYYY')),35),
AddYears(date(date#([Date of Birth],'DD.MM.YYYY')),60)
))

I'd better fix format on the data load to make expressions simpler.
You can figure out the rest, I assume.

[#3]

Date format isnt a problem we can convert to any suitable format.

[Anonymous]

Hello,

PFA

HTH

[Anonymous]

Exactly.

After you fix data format in the script, the expression fort the Retirement Date will be much simpler:

=date(rangemin(
AddYears([Employment date],35),
AddYears([Date of Birth],60)
))

Let me know if you need help with the other three.

[#6]

This abit helpful but date not correct i subtracted the dates online gettting a month difference.