Hi all, I have some date in excel  it have column date1 as 1/31/2011 4:42:40 AM when imported in SAS with format date9. it's shows as 31Jan2011 when I see the unformated value it's like  18658.196296. when I query the table it does not return any record. data new; format date1 date9.; input date1; datalines; 18658.196296 ; run;   /* But when I use below query the table it did not return any record*/   proc sql; select * from new where date1="31jan2011"D; quit; In Excel: Data1 1/31/2011 4:42:40 AM   data new; format date1 date9.; input date1; datalines; 18658.196296 ; run;   Gives: date1 31Jan2011   But when I use below query the table it did not return any record   proc sql; select * from new where date1="31jan2011"D; /*datepart is also not working*/ quit;   Why this happening and how we can handle this.   ... View more