Get Full Day Name

[rustyfishbones]

Hi All,

This is my First Question on the Qlik Community, I am trying to get the full day name like, Monday, Tuesday etc...

If I type the following in a Text Object for Month it works

=DATE(RELOADTIME(),'MMMM') the result is April

However if I try the following for Day

=WEEKDAY(reloadtime()) the result I get is Sun, the result I need is Sunday

Hope you can help

Regards

Alan

[jolivares]

You have two options:  1st, modify the names of week in your script

SET DayNames='Monday;Tuesday...;

Or make a little table with the inline command containing the days of the week.

[sushil353]

Best way is to change the environmental variables

SET DayNames='Monday;Tuesday;Wednesday;Thursdat;Friday;Saturdat;Sunday';

HTH

Sushil

[sujeetsingh]

yes it is the right approach just put you expression in nested if as

If(exp='Sun',Sunday..like this..you can get it in your expression.

[#5]

Hi Alan,

Change the below variable in the edit script and use weekday() function

SET DayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Thanks,

Sampath

[jagan · Accepted solution]

Hi Alan,

Try this

=DATE(Today(),'WWWW')

Hope it helps you.

Regards,

Jagan.

[rustyfishbones]

Hi Jagan,

That's exactly what I was looking for thank you

why is it not 'DDDD' is there a reason for that?

Regards

Alan

[jagan]

Hi Alan,

I am not sure about DDDD, I think DD is for representing Day number and WWWW is for representing weekday. 

Hope this helps you.

Regards,

Jagan.

[dagrun]

where do i find the edit script?