Forum Discussion

jochendecraene's avatar
jochendecraene
Helper V
5 years ago
Solved

Convert days to year

Hi   I used this code to calculate the difference between 2 dates    Duration.Days(Duration.From([Date_Today]-[Date]))   This gives me the proper result in days, but can I convert these days in...
Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    5 years ago

    jochendecraene 

    Your formula will go as :

    Number.RoundDown(
Duration.Days(Duration.From([Date_Today]-[Date]))/365.25,
0
)



Fowmy's avatar
Fowmy
Super User
5 years ago

jochendecraene 

Your formula will go as :

Number.RoundDown(
Duration.Days(Duration.From([Date_Today]-[Date]))/365.25,
0
)



jochendecraene's avatar
jochendecraene
Helper V
5 years ago

Fowmy Thx

 

Can you just explain how the formula works?

 

Thnx!

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    jochendecraene 

    First, calculate the days difference as oer your formula,
    Divide it by 365.25 (.25 added to include leap year as it comes once in 4 years), you get the year with fraction.
    Round it down to show only full completed year(s).