YearToDate example clarification - Qlik Help Referrence

[sai_katare]

Hi All,

I was trying to understand YearToDate function in QlikSense Help and i am unable to understand the following: 

How can this be true for a script reload date of 18/11/2011 ?

Here ('2010-11-18',  -1) would offset to date '2009-11-18' right? And '2009-11-18' does not fall in the range of '2011/01/01 to 2011/11/18' which YearToDate function is calculating.

Please let me know if I am missing any logic here or Qlik help needs an update here.

[ManuelLindekeit · Accepted solution]

The offset is applied to the last reload date. So in the example the -1 offset moves 2011-11-18 to 2010-11-18 and then tests if 2010-11-18 is in 2010. 

Hence, TRUE is returned for yeartodate( '2010-11-18', -1).

[sai_katare]

Thanks ManuelLindekeit.

I was thinking the offset is applied on the expression date. Thanks for the clarification.