Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You have to just remove the weekday() from the expression. Try like:
=UPPER(date(today(),'WWWW'))