Our website is for a local Volleyball league, the schedule for all the games are listed in a Collection called TestSchedule. I have a table [#table1] connected to a dataset [#dataset5] that links to that collection. I would like the table to only show games where the date field [GameDay] equals today.The values in the GameDay field are just the dates (time is set to 00:00:000). I have tried to use setfilter() to .eq the GameDay to date(). No joy. New to programming in corvid and novice with javascript. please help.
You can find a solution to a very similar question in this thread : https://www.wix.com/code/home/forum/questions-answers/display-different-a-image-from-a-db-based-on-date-range
Use filter options to customize the query.
https://www.wix.com/code/reference/wix-data.WixDataFilter.html
Note that not all filter options are compatible with a ‘date’ type.