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

dmalhotra — Fri, 09 Mar 2018 10:18:08 GMT

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.

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

SASKiwi — Sat, 10 Mar 2018 02:01:33 GMT

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

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

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

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