Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Valued Contributor

Strange date formatting behavior

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.



Tags (2)
2 Replies

Re: Strange date formatting behavior

Seems like a duplicate thread, I have responded here: Strange data formatting behaviour



Valued Contributor

Re: Strange date formatting behavior

I posted in QlikView too, I've not encountered this before, thought I would ask both audiences.