Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

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.

paul_scotchford
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.

Thanks

Paul

Tags (2)
2 Replies

Re: Strange date formatting behavior

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

Best,

Sunny

paul_scotchford
Valued Contributor

Re: Strange date formatting behavior

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

Thanks