cancel
Showing results for 
Search instead for 
Did you mean: 

Formula convert in till time month from hire date

RavindraKumar
Explorer
0 Kudos
292

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

Accepted Solutions (0)

Answers (1)

Answers (1)

xavierlegarrec
Product and Topic Expert
Product and Topic Expert
0 Kudos

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
Explorer
0 Kudos

Thanks xavierlegarrec .

i use lookup table function now its working ..

Thanks