38 Replies Latest reply: Oct 29, 2015 4:54 PM by Sinan Ozdemir RSS

    missing expression from SQL

    Mark Graham

      Hi all,

       

      I'm trying to fetch the records which were greater than 10/28/2015 05:10:55 PM from SQL through qlikview script.

       

      I have field "Last updated Date time" which holds that value.

       

      But when i use,

       

      SQL SELECT

      *  

      FROM  Table WHERE DATETIME(LAST_UPDATE_DATETIME) >='10/28/2015';

       

      It's throwing "missing expression from SQL" error.

       

      Can some one please help me to get into the right format.