Qlik Community

App Development

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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