Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

igdrazil
Contributor III

Date Extrapolation

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

Tags (2)
1 Solution

Accepted Solutions

Re: Date Extrapolation

Hi Christoph, there is a AddYears() function:

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

2 Replies

Re: Date Extrapolation

Hi Christoph, there is a AddYears() function:

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

igdrazil
Contributor III

Re: Date Extrapolation

Hi Ruben,

thanks for your reply!

Regards

Chris