2 Replies Latest reply: Dec 29, 2017 7:21 AM by Janani Reddy RSS

    Date format in QVD where condition

    Janani Reddy

      Hi Guys,


      I am having trouble to get a QVD evaluate its where condition.The condition i am applying is to load records whose date is less than a certain date 


      Below is the script used in the data load editor:


      Load date(max(ApplicationDate),'DD/MM/YYYY') as vDate From [lib://QVD/Branch.QVD] (qvd) ;

      Load * From [lib://QVD/LOANSHISTONETIMENEW.QVD] (qvd)

      where date(DateBrn,'DD/MM/YYYY') = DATE(DATE#('vDate','DD/MM/YYYY'), 'DD/MM/YYYY') ;

      I have read this very helpful link before posting this question, but i couldn't solve my issue

      Dealing with date formats in QlikView and QlikSense

      These are some options i have tried to format the date. Hard coding the date works just fine but nothing else.

      //where date(DateBrn,'DD/MM/YYYY') < date#('vDate','DD/MM/YYYY');

      //where date(DateBrn,'DD/MM/YYYY') < date#('27/12/2017','DD/MM/YYYY'); // this worked a couple of times but it did not work the next day

      //where date(DateBrn,'DD/MM/YYYY') < '27/12/2017';

      //where date(DateBrn,'DD/MM/YYYY') < date('$(vDate)','DD/MM/YYYY');