Strange data formatting behaviour

[paul_scotchford]

Using the following formatting option in the Date() function , the Full Day is truncated and part of the year number is appended ...

Function ... Date("Date", 'WWWW') as FullDayName

Data ...   30Jun2015 = Tuesday015 ,  1Jul2015 = Wednesda15 , 4Jul2015 = Saturda15

Days of Sunday, Monday, Thursday, Friday are returned as expected.

Has this been noticed anywhere by anyone? Normally I don't generate the days this way, we load directly from a

SQL date dimension which has full days predefined.

Thanks

Paul

[paul_scotchford]

Indeed, just as well I use dates from a QVD generated on SQL data.

Thanks for your input today much appreciated.

[sunny_talwar]

Seeing this in QlikSense:

But this in QlikView:

[paul_scotchford]

Yep that's the issue.