how to display week names of the week of the month

[#1]

hi,

There is a requirement where in I have to display weeknames(Sunday, Monday,..) of the month in the bar chart.

Can anyone help me out to get the solution for the same.

Thanks in advance,

Smitha

[#2]

Hi Smintha,

I am a little confused with your post's header and the message body.

Are you trying to find the week number of the date in that month? For example, 12 Nov 2013 is 3rd week of the month. Is it what you are looking for? Then you can use

=(Week(Date)-Week(MonthStart(Date)))+1

If you are looking for names of the days to be displayed, then would you like to try WeekDay(Date) in your expression? ("Date" here represents the field name for your dates, feel free changing)

Let us know how it goes and hope it helps.

Best wishes,

[sadickbasha]

Please use 'WeekDay(date Field)' to display the week days

[#4]

Hi use weekday function

in dimension tab-use conditional dimension  like

weekday(date field)

then the result the dimesion values are shown as 

sun,mon,tue,.....

let me know is this u r requirement or not.

[#5]

Use Weekday(date field) it will display the day of the week in characters

[#6]

Hi Smitha,

Hope attached is helpful for you.

[mjm]

Please use the weekday() function. The day names will be taken from the default SET statements at the beginning of your load script.