How to get the day name from a date filed

[#1]

Hi Guys,

I have a date field in my qlikview sheet.

I want to make the corresponding day name out of it.

like Monday,Tuesday...

Which function i can use to get the day name?

Can somebody help?

Regds,

Sona

[swuehl]

Hi Sona,

you might use weekday(Date) function to get the Day names. weekday() will return a dual value, i.e. you could use num(weekday(Date)) to retrieve the week day number 0-6.

Day names are retrieved from the script:

Set DayNames = 'Monday;Tuesday;Wednesday;..'

Hope this helps,

Stefan

[#3]

Hi Praveena,

You can use the  WeekDay() function along with changes in the default DayNames set in the script to achieve this. You can check the attached file

Regards

DS

[rajkumart]

WeekDay()