Formula convert in till time month from hire date

[RavindraKumar]

Hi

Thanks for this blogs. this is very use full

Is any formula for Hire date - current system date (by default) convert in total month.

example

Hire Date 1/1/2020

Current System Date 29/08/2023

so value should show 43 month

Regards

Ravindra

[xavierlegarrec]

Hi ravindrasharma87

You can divide the number of days (explained in the blog) by 30 and it will give you an estimate of the number of months.

There is no way I know of to make it always 100% exact however. If you want that you would need to build it through a custom MDF object where there is a business rule that allows for 100% months calculation based on the number of days of each month within the period.

All the best

Xavier

[RavindraKumar]

Thanks xavierlegarrec .

i use lookup table function now its working ..

Thanks