<div>
If you don't need a high precision, this will do:<br />
<br />
DecimalYears = CDbl(Format(DateDiff(&quot;d&quot;, datFrom, datTo) / 365, &quot;0.0&quot;))<br />
<br />
/gustav
</div>


If you don't need a high precision, this will do:

DecimalYears = CDbl(Format(DateDiff("d", datFrom, datTo) / 365, "0.0"))

/gustav

<div>
<div class="content wysiwyg-content">
I have this formula:<br />
<br />
Me.txtCurrentLifeOfAsset = Int(([txtDateInventoryPerf<wbr />ormed] - [txtDateofPurchase]) / 365.25)<br />
<br />
Which calculates the difference between two dates in whole years. &nbsp;For example 6/1/2014 - 3/1/2009 is giving me 5.0 years. &nbsp;But I want it to show the decimal. &nbsp;In other words 5.2<br />
<br />
What do I have to change in the formula to make this possible?
</div>
</div>


I have this formula:

Me.txtCurrentLifeOfAsset = Int(([txtDateInventoryPerformed] - [txtDateofPurchase]) / 365.25)

Which calculates the difference between two dates in whole years.  For example 6/1/2014 - 3/1/2009 is giving me 5.0 years.  But I want it to show the decimal.  In other words 5.2

What do I have to change in the formula to make this possible?

Round date difference to nearest single decimal

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.