Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Dates

I have a start date. I need to get end date as 3 years from start date. How do I acheive this??

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Dates

EndDate = AddYears(StartDate,3)

4 Replies
mov
Esteemed Contributor III

Re: Dates

EndDate = AddYears(StartDate,3)

Not applicable

Re: Dates

hi ,

for EndDate try this..

    

     YearStart(StartDate, 3)   or  YearEnd(StartDate, 3)      //According to your need

Regards

Ashutosh

Re: Dates

Hi

Exactly if you  need three years from startDate, then use

AddYears(StartDate,3)

ex: AddYears(Today(),3) gives 11/26/2016

or

You need three years after startDate, then use

YearEnd(StartDate,3)

ex: YearEnd(Today(),3) gives 12/31/2016

Not applicable

Re: Dates

thank you..

Community Browser