Qlik Community

App Development

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
philip_radovich
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. 

 

Thanks,

Phil 

1 Reply
rwunderlich

Can you do:

(EndDate - StartDate) / 365

-Rob