https://community.qlik.com/t5/App-Development/Date-Difference-as-Decimal/m-p/1594262#M43705 <P>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.&nbsp;</P><P>StartDate = 2013-12-18</P><P>Ex:&nbsp;(Today()- (StartDate)) = 5.5</P><P>I have read through the community but all of the proposed solutions have not worked for me. Any help or direction is greatly appreciated.&nbsp;</P><P>&nbsp;</P><P>Thanks,</P><P>Phil&nbsp;</P> Thu, 20 Jun 2019 16:06:19 GMT philip_radovich 2019-06-20T16:06:19Z https://community.qlik.com/t5/App-Development/Date-Difference-as-Decimal/m-p/1594262#M43705 <P>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.&nbsp;</P><P>StartDate = 2013-12-18</P><P>Ex:&nbsp;(Today()- (StartDate)) = 5.5</P><P>I have read through the community but all of the proposed solutions have not worked for me. Any help or direction is greatly appreciated.&nbsp;</P><P>&nbsp;</P><P>Thanks,</P><P>Phil&nbsp;</P> Thu, 20 Jun 2019 16:06:19 GMT https://community.qlik.com/t5/App-Development/Date-Difference-as-Decimal/m-p/1594262#M43705 philip_radovich 2019-06-20T16:06:19Z https://community.qlik.com/t5/App-Development/Date-Difference-as-Decimal/m-p/1594302#M43721 <P>Can you do:</P><P>(EndDate - StartDate) / 365</P><P>-Rob</P> Thu, 20 Jun 2019 18:30:47 GMT https://community.qlik.com/t5/App-Development/Date-Difference-as-Decimal/m-p/1594302#M43721 rwunderlich 2019-06-20T18:30:47Z