Hi everyone,
has anyone ever experienced this case or know how to make it works. I'm trying to filter the content in the repeater based on the voucher expiry date, but this will only work if the date format I use in the database is "date and time" meanwhile the date that triggers expire comes from the date picker and it doesn't work because of the format used different
![](https://static.wixstatic.com/media/a27d24_c4402c6ca32b463991362b06eb3925b8~mv2.png/v1/fill/w_846,h_275,al_c,q_85,enc_auto/a27d24_c4402c6ca32b463991362b06eb3925b8~mv2.png)
if i want this to work i have to manually convert this date format.
and this is my code for filtering :
const today = new Date();
wixData.query("collection name")
.gt("dateField", today)
.find()
.then((results) => {
$w(`#repeater1`).data = results.items;
})
.catch((err) => {
let errorMsg = err;
});
$w(`#repeater1`).onItemReady(($w, itemData) => {
});
Please help if anyone understand this, thank you