topic Week day displaying Alpha week name not int in QlikView

Week day displaying Alpha week name not int

Wed, 07 Apr 2010 18:18:37 GMT

=weekday(today(0)) is displaying (wed). However, according to the help it should display the day of week as an integer. That is my goal, am I missing a setting?

Thanks,

Week day displaying Alpha week name not int

Miguel_Angel_Baeyens — Wed, 07 Apr 2010 18:26:33 GMT

Hello Anthony,

Actually, manual/help is wrong when it says it returns an integer (indeed, returns the short day name following the variable "DayNames" at the beggining of your script). But you can easily convert it into number

Num(WeekDay(Today(0)))

Hope that helps.

Week day displaying Alpha week name not int

Wed, 07 Apr 2010 18:33:33 GMT

Thanks for the response. While i was waiting i actually did that.. in fact this is my exact code. =num(weekday(today(0))). Except for the result is 2. When i take off num it's "WED". I wouldn't think wed would be day two?

Thanks,

Week day displaying Alpha week name not int

Wed, 07 Apr 2010 18:47:18 GMT

Looks like it starts the week on monday at 0.

Thanks,