intck and date format

[Geo-]

log_date	cst_id
09Dec2016	101
20Jan2016	102
16Jul2015	103

The format of column "log_date"  is DATE9.

proc sql;

select * from tableA

where intck('dtday',log_date,'01apr2018'd) >=30;

run;

the code return no rows,why and how to fix?

thanks!

[novinosrin]

Is your log_date var character by any chance formatted with date9.?

And can you post your log message plz?

[SASKiwi · Accepted solution]

You are using DTDAY which is a datetime interval not a DATE one. Use DAY instead.