This content has been marked as final. Show 3 replies
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.