Day name not correct

BEKEGE — Wed, 09 Jun 2021 06:50:55 GMT

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.

Re: Day name not correct

tresB — Wed, 09 Jun 2021 07:07:16 GMT

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

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