https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Date-time-issues/m-p/69503#M6936 Check your YEARCUTOFF option in SAS. If it is 1900, then change to 2000. If it is 2000, then the problem is in your Excel setup. Fri, 04 Sep 2009 15:46:55 GMT Doc_Duke 2009-09-04T15:46:55Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Date-time-issues/m-p/69502#M6935 I am trying to build a simple conversion table so that I can easily convert my data into date, working day, period, month, year, etc...whenever I want.<BR /> <BR /> It is simply the above headings with their associated values, created in Excel. The plan was to turn it into a SAS dataset, however it's not working.<BR /> <BR /> When I open my table in EG 'month&amp;year' (mmmyy) and 'date' (ddmmyy) are being converted into datetimes (I understand why this happens). I have used the DATEPART function to split the numbers but it is not producing the correct results, i.e. 1st Sep 09 is giving me a date from 1949!!!<BR /> <BR /> Any ideas? Fri, 04 Sep 2009 13:11:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Date-time-issues/m-p/69502#M6935 deleted_user 2009-09-04T13:11:12Z https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Date-time-issues/m-p/69503#M6936 Check your YEARCUTOFF option in SAS. If it is 1900, then change to 2000. If it is 2000, then the problem is in your Excel setup. Fri, 04 Sep 2009 15:46:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-Date-time-issues/m-p/69503#M6936 Doc_Duke 2009-09-04T15:46:55Z