Dataset filters week events

if there a filter for data sets that allow me to show events from monday to sunday for that week

for example only dates from 20/11/2017 to 26/11/2017 are shown then it would move to next week

for would i have to do it so it shows a week from today and have that move along

You don’t want to put dates in the filter, as with that you’d need to edit it every week (other than that it is feasible of course).

What you had some time ago ie
Col1 >= CURDATE() AND Col1 < CURDATE() + INTERVAL 7 DAY

would work ok, but if you don’t want it to show any data from ‘next’ week, then you’d need to put dates for let’s say Monday on all rows and then next Monday’s date on rows from next week and so on.

is there any way of doing my idea with a week being date and a week end date

so week being 04/12/2107 and week end 08/12/2017, and if current date is between those two points show the data

Well yes you could do that

Start <= CURDATE() AND End >= CURDATE()

Where:
Start => column with start of the week date
End => column with end of the week date

or

CURDATE() BETWEEN Start AND End

which is essentially the same, just with different function.