Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I posted in QlikView too, I've not encountered this before, thought I would ask both audiences.
Thanks