Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Weekstart - Problems when today() = Monday!

Hey

I've run into a strange problem. I have a straight table with a current week overview per day, and then I'm also showing the following Monday and Tuesday.

For the following Monday and Tuesday I've added the actual date into the label to avoid any confusion for the user. Normally this works as it's supposed to do except on Mondays(!), where my Tuesday date goes wrong and stays in the current week. See below from today, where it's showing 24.01 where it should show 31.01:

Formula for Monday label, which is working "='+1 Mon' & ' ' &date(WeekStart(Today(),1,0),'DD.MM')"

Formula for Tuesday label, which is not working on Mondays "='+1 Tue' & ' ' &date(WeekStart(Today(),1,1),'DD.MM')"

Any ideas?

Tuesdays.PNG

1 Solution

Accepted Solutions
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

"='+1 Tue' & ' ' &Date(WeekStart(Today(), 1, 0)+1),'DD.MM')"

Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

2 Replies
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

"='+1 Tue' & ' ' &Date(WeekStart(Today(), 1, 0)+1),'DD.MM')"

Help users find answers! Don't forget to mark a solution that worked for you!
Anonymous
Not applicable
Author

Thanks Aurélien

The +1 idea works, though I've placed it after the Today()

='+1 Tue' & ' ' &date(WeekStart(Today()+1,1,1),'DD.MM')

I can't get my head around why this doesn't screw up the formula on Sundays, but I've simulated them, and I still get the right result, so thank you!