datetime20. format filtering in where clause

[ashwini2]

proc sql;
select distinct MINOFTRANSFER_EFF_DT
from HSD.master_table
where MINOFTRANSFER_EFF_DT between '01APR2016'd and '30JUN2016'd
;
quit;

I am trying to filter data based on the date and it returns no values.

MINOFTRANSFER_EFF_DT is in datetime20. format.

[ballardw · Accepted solution]

You are comparing a Datetime to Date values. Try

where Datepart (MINOFTRANSFER_EFF_DT) between '01APR2016'd and '30JUN2016'd

to compare the date of the datetime