I thought this would be simple, but I can't figure out why I can't filter results by date.
I'm just trying to filter the dataset for dates greater than today. This is my code. The database field called 'date' is of type "Date and Time".
var today = new Date(); today = Date.now(); $w('#dataset1').setFilter(wixData.filter() .contains('provinceState', $w('#iState').value) //ignore this as it works fine .ge('date', today) //when I add this line, my results are empty whether I use ge, or le
.contains('visibility','public')) //ignore this as it works fine also
Any ideas as to what I'm doing wrong?