topic Dates in QlikView

Dates

Mon, 25 Nov 2013 21:56:56 GMT

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

Anonymous — Mon, 25 Nov 2013 22:05:52 GMT

EndDate = AddYears(StartDate,3)

Tue, 26 Nov 2013 05:39:28 GMT

hi ,

for EndDate try this..

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

Regards

Ashutosh

MayilVahanan — Tue, 26 Nov 2013 05:45:13 GMT

Exactly if you need three years from startDate, then use

AddYears(StartDate,3)

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

You need three years after startDate, then use

YearEnd(StartDate,3)

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

Tue, 26 Nov 2013 14:17:57 GMT

thank you..