3 Replies Latest reply: Oct 10, 2018 9:01 PM by Bala Bhaskar RSS

    SELECT from SQL Database issue

    Zhitao Gao



      i'm having trouble using DataManager loading data from a database.



      I already connected my APP with database and try to get some rows in the table.


      There is a colum 'FILLINDATE' in this table. And I want to apply a filter before loading from the table, so I dont have to load all data from the table. This colum has the format" 01/01/2016 00:00:00 AM"


      As my understanding, applying this filter equals adding the read "Where FILLINDATE>='2018'" below.







      FROM xxx Where FILLINDATE>='2018'

      I tried several SQL such as CONVERT(), or Date but none of these works.

      Thanks for any tips.