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
Give this a shot:
=Date(Date#(DateField, 'DMMMYYYY'), 'WWWW')
=Date(Date#(DateField, 'DDMMMYYYY'), 'WWWW')
Hi Sunny
This does not work in my script, returns NULL
Thanks
You date field looks like this -> 30Jun2015 (DDMMMYYYY)? or does it follow another format??
Correct this is our format. I think this is a bug perhaps.
The reason I have not noticed this before is that we generate our calendars in SQLServer and
load up a QVD which has days in it.
Just happened across this issue by chance.
QlikView seemed to have handled it, let me test it on Qlik Sense.
Ok thanks
So this seems to work in QlikView:
=Date(Date#(DateField, 'DDMMMYYYY'), 'WWWW')
but showing just Wednesda (without y for 1Jul2015).
Checking it further on Qlik Sense
Would you say that is working dropping the 'y' is a failure in the function to return the expected value.
Ya I would expect to see the whole Wednesday. In Qlik Sense, it isn't doing that, so to me it seems like a bug.
But in QlikView it is showing perfectly (Wednesday)