topic How to select dates with the API syntax? in QlikView https://community.qlik.com/t5/QlikView/How-to-select-dates-with-the-API-syntax/m-p/872503#M659626 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>What is the correct syntax for selecting date fields in the API?</P><P></P><P>app.field('LastName').selectValues([{qText: "Andersson"}], true, true);</P><P></P><P>works for texts, but</P><P></P><P>app.field('Created Date').selectValues([{qText: "2014-10-30"}], true, true);</P><P></P><P>does not work for dates.</P></BODY></HTML> Tue, 21 Apr 2015 09:47:34 GMT 2015-04-21T09:47:34Z How to select dates with the API syntax? https://community.qlik.com/t5/QlikView/How-to-select-dates-with-the-API-syntax/m-p/872503#M659626 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>What is the correct syntax for selecting date fields in the API?</P><P></P><P>app.field('LastName').selectValues([{qText: "Andersson"}], true, true);</P><P></P><P>works for texts, but</P><P></P><P>app.field('Created Date').selectValues([{qText: "2014-10-30"}], true, true);</P><P></P><P>does not work for dates.</P></BODY></HTML> Tue, 21 Apr 2015 09:47:34 GMT https://community.qlik.com/t5/QlikView/How-to-select-dates-with-the-API-syntax/m-p/872503#M659626 2015-04-21T09:47:34Z Re: How to select dates with the API syntax? https://community.qlik.com/t5/QlikView/How-to-select-dates-with-the-API-syntax/m-p/872504#M659628 <HTML><HEAD></HEAD><BODY><P>You could try using the numeric value of the date instead.</P><P>Num('2014-10-30') would be 41942</P></BODY></HTML> Wed, 22 Apr 2015 07:16:02 GMT https://community.qlik.com/t5/QlikView/How-to-select-dates-with-the-API-syntax/m-p/872504#M659628 Ralf-Narfeldt 2015-04-22T07:16:02Z Re: How to select dates with the API syntax? https://community.qlik.com/t5/QlikView/How-to-select-dates-with-the-API-syntax/m-p/872505#M659632 <HTML><HEAD></HEAD><BODY><P>Thanks for the idea, but that does not seem to work either.</P></BODY></HTML> Wed, 22 Apr 2015 07:35:58 GMT https://community.qlik.com/t5/QlikView/How-to-select-dates-with-the-API-syntax/m-p/872505#M659632 2015-04-22T07:35:58Z