SAS VA : Date Comparison in Query Builder not giving correct Result

[dmalhotra]

Hi All,

I am working on Data Preparation tab in VA7.3.  In one datasetfrom VALIBLA , which keeps getting refreshed  , there is  date timestamp  column which I am trying to compare with a hardcode date. Column Type is Datetime. In where tab I am inserting expression as SAMPLEDATA.CREATE_DTTM> "01Jan2018:00:00:00"d , its giving result but showing all dates, basically not comparing . I tried using Function datepart also , which gives error that data is not parsed, though its not allowing to use Parse function. How to solve this.

[SASKiwi]

If you are comparing with a datetime constant then try this: SAMPLEDATA.CREATE_DTTM> "01Jan2018:00:00:00"dt