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 into years?

 

so that ex 65 days  = 0 years, 521 = 1 year ...

 

thx

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
)



3 Replies

  • 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
)



      • 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).