Multiple date values does not work with match function i the script editor

[Swarup_MOA]

Hello,

when using muiple date values in where clause along with match funtion, qlik does not return anything? Please advice, how can we use mutiple date values in where clause of the load editor?

 Load *

where match (My_DateField ,'2023-08-02','2023-09-13','2023-10-02','2023-10-30','2023-11-01','2023-11-02','2023-12-01','2023-12-05','2023-12-11','2023-12-12','2024-01-02','2024-01-11','2024-01-31',
'2024-02-01','2024-02-05','2024-02-08','2024-03-01','2024-04-01','2024-04-03','2024-04-10','2024-04-15','2024-04-18','2024-04-19');

[rubenmarin]

Hi, maybe the date field has another format, you can try setting the format as the value searched, like:

where Match(Date(My_DateField,'YYYY-MM-DD') ,'2023-08-02','2023...