Hi,
Another formula I can't figure out.... I want to have a filtering visible on a date column in my database. Visible should then be everything between today and today+7 days. This is what I have now, unfortunately not working :(
$w.onReady(function () { let today = new Date(); // today.setDate(today.getDate() + 604800000); $w('#dataset4').setFilter(wixData.filter() // .ge('datumTot', today) .ge('datumTot', new Date(Date.now() + 7 * 86400000)) ); });
const now = Date.now();
//filter...
$w('#dataset4').setFilter(wixData.filter()
.ge('datumTot' , now )
.lt('datumTot', now + 7 * 24 * 60 * 60 * 1000)
)