Weekday function taking a day off

[cfountain72]

Hi Qlikkers,

Must be doing something wrong, but when I apply the Weekday function, it gives me one day off from what the day should be. For instance, choosing Weekday() on 12/14/2020 gives me Sunday, but that date is actually a Monday. I tried adding Date to simplify the timestamp, as well as Floor, but nothing seems to work. (The load script has FirstWeekDay set as 6 (Sunday).)

Any suggestions?

Thanks in advance,

Chris

[JosephMorales · Accepted solution]

Hi @cfountain72 

Could you check the DayNames variable in the script editor?
It should be as follows
SET DayNames = 'mon; tue; wed; thu; fri; sat; sun';

Regards

Joseph Morales

[cfountain72]

Amen Brother! That was it. Not sure how that got changed, but I adjusted it back, and it's all good now.

Thanks again,

Chris