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

Swarup_MOA — Sat, 27 Apr 2024 03:55:54 GMT

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');

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

rubenmarin — Sat, 27 Apr 2024 05:51:08 GMT

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...

topic Multiple date values does not work with match function i the script editor in App Development

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

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