4 Replies Latest reply: Nov 23, 2015 3:04 AM by Mira Rai RSS

    Date issue in where clause in SQL statement in Qlikview

    Mira Rai

      Hi,

       

      I  am creating a table in qlikview using sql query. Query works fine in SQL returns records (Oracle Database) but the same  query returns zero records in Qlikview. I am using variable to get '30-JUN-15' this value but it was not returning anything so tried using hard code value but still the same problem.

      ABC:

      Load *;

      SQL Select * from xyx where TDTIME='30-JUN-15';

       

      I tried changing date formats but its not working. I dont want to use script like as i already have huge data set.

      ABC:

      Load * where TDTIME='30-JUN-15';

      SQL Select * from xyx;

       

      Any help.? Thanks you.