Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
Hi Christoph, there is a AddYears() function:
AddYears(Date, [Number of years to add])
thanks for your reply!