Hi I am trying to set up an events page that will filter results based on three drop down fields. Genre, Location and Date
The Genre and location are fine and working.
However the date picker I am finding hard
In the datebase there are two fields start date and end date
lets say one event as a start date of 25.10.22 and end date 28.10.22
One the user end if a user selects from date picker 27.10.22 I need that entry to show up
also needs like the other three to be optional
This is the code I have but it is not working I know its something to do with the between() bit dont know the exact syntax
$w(“#text44”).hide(); let today = new Date() // let sToday = new Date().toISOString().split(‘T’)[0]; $w.onReady(function () { $w(“#eventsDataset”).onReady(() => { let sToday = new Date(); $w(“#eventdDataset”).setFilter(wixData.filter().ge(“date”, sToday)); }); }); export function searchButton_click(event) { search(); } function search(){ wixData.query(“Exhibition”).ge(“date”, today) .contains(“arraystring”, String($w(‘#dropdown1’).value)) .and(wixData.query(“Exhibition”).contains(“showstring”, String($w(‘#dropdown2’).value))) .find() .then(results => { $w(‘#listRepeater’).data = results.items ; if($w(‘#listRepeater’).data.length ===0){ $w(“#text44”).show(); } else { $w(“#text44”).hide(); } }) }
This is an image of the front end
I am stuck with this and cant find much online so any help welcomed