Dear Community,
Please can you help me with creating a SQL filter regarding dataset ticker.
I have the following columns: ID, Weeknr, Name, Date.
The rows are as followed:
CURRENT WEEK–> Row 1: ID: 21, Week: 40, Name: , Date: 02-10-2023(Dutch time notation)
Row 2: ID: 21, Week: 41, Name: , Date: 02-10-2023(Dutch time notation)
Row 3: ID: 21, Week: 42, Name: , Date: 09-10-2023(Dutch time notation)
Row 4: ID: 21, Week: 43, Name: , Date: 16-10-2023(Dutch time notation)
Row 5: ID: 21, Week: 44, Name: , Date: 23-10-2023(Dutch time notation)
With following filter i can show current week:WEEK(Datum, 1) = WEEK(CURDATE())
What i want is creating a filter that shows the upcoming 4 weeks based on current weeknr.
So what i need is Weeknr from row 2-5 and name from row 2-5
Best Regards,
Tim