Date Extrapolation

[igdrazil]

Hi Community,

as the title says, i wanna know if i can extrapolate my Dates.

Right now i'm doing this via:

Date(Date(Pickdate) + x*365)

x is a Variable set to any integer Value.

So it adds a "normal" year by adding 365 days but we have 366 days a year every 4 years, so when my x is getting bigger, i get wrong dates.

Regards

Chris

[rubenmarin · Accepted solution]

Hi Christoph, there is a AddYears() function:

AddYears(Date, [Number of years to add])

[igdrazil]

Hi Ruben,

thanks for your reply!

Regards

Chris