Hi, I am importing a .txt file which has a column name date of birth in the format 06JUN2012:10:32:13. In the file system its in Char format and now i want to change the vale to numeric date9. .i.e. 06JAUN2012. In the expression window ( File reader), i used put(datepart(DOB),DATE9.) but some how its not working. Is am missing anything here? Please help! Thanks
... View more