Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.