# Years Between Dates

[microwin88x]

Hello,

I need to create a field with the number of years between a date and the 31/12 from the year I run the script.

(In this case would be 31/12/2017 but next year would be 31/12/2018).

I previously had AGE(TODAY(), MY_DATE) but I need to modify the function.

Do you know how to do that?

Thank you!

[marcus_malinow · Accepted solution]

AGE(YearEnd(Today()), MY_DATE) perhaps

[Anil_Babu_Samineni]

May be NetWorkDays function you mean to say or YearEnd() function for Today() declaration.