Day name not correct

[BEKEGE]

Hello,

I have a little problem with the dates.

I realized when I wanted to retrieve the days of the week in text from a date that there were inconsistencies.

So I tried to retrieve the day of the week from the today () function.

UPPER(date(WeekDay(today()),'WWWW')) As day_today,

And indeed Qliksense gives me the day Monday while it is Wednesday.

Can you help me?

thank you,

Kevin.

[tresesco]

You have to just remove the weekday() from the expression. Try like:

=UPPER(date(today(),'WWWW'))