Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you fix a month of 30 days then
floor((enddate - today())/30) & ' Months ' & mod(enddate - today(),30) & ' Days '