Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Date Difference as Decimal

I am trying to figure out the date difference between two dates but the value displayed as a whole number(years) and decimal(months). I can do Year(Formula) to get a whole number but my requirement is to display the value to the .00. 

StartDate = 2013-12-18

Ex: (Today()- (StartDate)) = 5.5

I have read through the community but all of the proposed solutions have not worked for me. Any help or direction is greatly appreciated. 




1 Reply

Can you do:

(EndDate - StartDate) / 365