filter database on yesterday

Ask the community
,
1

Hi,

I am trying to create a filter so that my database shows yesterday and later date.

This is what I have now, in the log file I do see yesterday’s date, but the filter does not work on my database.

$w . onReady ( function yesterdayDateNum () {
let today = new Date ();
let todayTime = today . getTime ();
// 86400000 milliseconds in a day
let yesterdayTime = todayTime - 86400000 ;
let yesterday = new Date ( yesterdayTime );
console . log ( yesterday );
$w ( ‘#dataset1’ ). setFilter ( wixData . filter ()
. ge ( ‘date’ , yesterday )
);
});

2

sorry, i was working in sandbox and not in live :pensive:

3

Hi!

Try out:

$w.onReady(function yesterdayDateNum () {
    let today = new Date();
    let todayTime = today.getTime();
    let yesterdayTime = todayTime - 86400000;
    let yesterday = new  Date(yesterdayTime);
    let tomorrow = new Date(todayTime + 86400000);
    console.log(yesterday);
    $w('#dataset20').setFilter(wixData.filter()
        .between('date', yesterday, tomorrow)
    ).then(() => {
        $w("#dataset20").setFilter(wixData.filter())
    });
});
1 Like
4

Hi,

Thanks for your response.

Is it also possible that when the date falls outside the filter, my view refreshes automatically, without having to press F5 myself and not the entire page being refreshed?