I am trying to query a Collection by getting records that have been changed AFTER a certain date. No matter what date I pass in ALL the records keep returning. Please advice what I am doing wrong.
Here is my code
let today = new Date();
let theDate = new Date();
//Add a random number of days to test the variable
theDate.setDate(today.getDate() +4);
console.log(theDate);
let Qry= await wixData.query("Members/PrivateMembersData").gt("_updatedDate",theDate).find();
console.log(Qry);
My expectation was that only records where the _updatedDate value was greater than the value in theDate would be returned. But ALL the records are being returned.
Please advice
Thanks