Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

Number of days in Month and days

Hi all,

 I have a expression where i am finding remaining days  with expression 

 contract line enddate - today().

 

But i want to display no of days as months and days

 like 95 days becomes  3 months 5 days.

 

Can someone pls help me?

 

Kind Regards

Manu

1 Reply
pradosh_thakur
Master II
Master II

If you fix a month of 30 days then

floor((enddate - today())/30) & ' Months ' & mod(enddate - today(),30) & ' Days '

Learning never stops.