I have created a dataset with 6 columns, one of them is ‘Day’ , a list of strings (Sun,Mon,Tue etc.)
The dataset is kind of weekly schedule, so I created it as a list of strings so it will be easier for the user to fill the data in the dataset by selecting the date from the dropdown when filling manually.
In the layout , I have added a region with DataSetView, I would like to filter only the records from the dataset that include the current day of the week.
I have tried several ways to filter the dataset, like:
Day = DATE_FORMAT(CURDATE(),’%D’)
Day = DATENAME(weekday, DATE())
Day = DAYNAME(NOW())
but none returns data / the desired result.
(I guess you see I’m confused and not sure what path to go with SQL, although I know that the DB behind the CMS is MySQL)
What am I missing?
I have come to understand that the syntax is right, since I get the “No Data returned…” message, while when there is a syntax error, no message appears on the region,
but still I cannot seem to get the filtered data displayed.
Any help would be greatly appreciated.