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")
Solved! Go to Solution.
you want to change that from "years" to "days" (or hours) and then do the division... DateTimeDiff gives an integer as an output.
@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