subtract two dates and divide by 365.25

Question

Hi,

I am trying to do this formula:

Date 1 - Date 2 / 365.25 OR

maturity date - run date / 365.25  OR

31-Mar-26  -   30-Sep-19  / 365.25

I am expected 6.50 as the answer.

However I am getting 6 when I do this:

DateTimeDiff([ Maturity Date ],[ Run Date ],"years")

OllieClarke · Accepted Answer

@wonka1234 DateTimeDiff() will always return an integer value. Which is calculated as the number of complete periods between the dates. So if you want decimal values, then you need a smaller datepart - e.g. months. You can then divide this number by e.g. 12