number of the week day

[#1]

Hi,

I want to set a variable value to the number of the weekday

So today is Thursday so the variable value should be '4'

When I try following then I get value as 'Thu'

=Weekday(Today())

But When I convert to number like below.. then I get Value as '3' instead of '4'

=num(Weekday(Today()))

am I missing anything?

[Gysbert_Wassenaar · Accepted solution]

Days start at 0. Monday is day 0. See the only help: weekday - script and chart function ‒ Qlik Sense

[Chanty4u]

hi,

weekday(date)

Week day. Returns an integer between 0-6.

Example:

weekday( '1971-10-30' ) returns 5.

If the date format used does not correspond to the one set in your operating system, QlikView will not be able to make a correct interpretation.

[#4]

Thank you

[#5]

Thank you