topic Re: Weekday function taking a day off in App Development

Weekday function taking a day off

cfountain72 — Sat, 16 Nov 2024 00:41:43 GMT

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

Re: Weekday function taking a day off

JosephMorales — Wed, 03 Feb 2021 15:38:35 GMT

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

Re: Weekday function taking a day off

cfountain72 — Wed, 03 Feb 2021 15:44:15 GMT

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