Filter repeater by datepicker field

Ask the community
,
1

I want to filter my repeater base on voucher expire and this voucher expire data was from user input using datepicker. But I just getting problem why my filter code can’t read data from datapicker field on my database, the format read only using date and time meanwhile datepicker value is text, please help if anyone know how to solve this problem.

filter code :
const today = new Date ();
today . toLocaleString ();
// $w(“#datePicker1”).value = today.toLocaleDateString();
wixData . query ( “covid19HealthDeclaration” )
. gt ( “dateField” , today )
. find ()
. then (( results ) => {
//setting all the filtered data to the repeater
$w ( #repeater1 ). data = results . items ;
})
. catch (( err ) => {
let errorMsg = err ;
});
$w ( #repeater1 ). onItemReady (( $w , itemData ) => {
});

this code can’t read this field value

1512×331 24.3 KB

this is very urgent to me :"(, thanks if anyone willing to help me

2

Sure that your FIELD-ID is → “dateField” and not something like → “voucherExpire” ???

Also use CONSOLE to investigate and analy your own code…

const today=new Date(); console.log(today);
const todayLocal = today.toLocaleString(); console.log(todayLocal);
3

Thank you for responding, yes I’ve make sure the field name has been correct

4

Can you show a screenshot of opened property-menu-panel of →

5

This is my properties

612×636 24.9 KB

6

my code only read this date format

1764×558 77 KB

7

Yes, thats correct!

Ok, we checked your DB-FIELD-ID and it was indeed, correct!
Your problem is the wrong used DATE-Format for comparisson.

You can have several different DATE-Formats.

That means, if you want to make a COMPARISSON between two different DATES, both of them have to be in the SAME/IDENTICAL FORMAT!

const today = new Date();  console.log(today)
const todayLocale = today.toLocaleString(); console.log(todayLocale)
const todayLocaleDate = today.toLocaleDateString(); console.log(todayLocaleDate)