Date function not working on all data

[#1]

I have data that represents a date in the format 'YYMMDD' and I am converting it to a readable date format of 'MM/DD/YYYY' with the following script:

This is working for most of the dates but there are a few that are not coming over in the correct format:

The 040806 toward the end should be coming in as 10/11/2011 and the 040623 at the bottom should be 03/21/11. Any thoughts on why this works on some but not others?

[mphekin12]

Have you tried something like this in the load script:

timestamp(OriginalDate,'M/D/YYYY h:mm:ss[.fff] TT') as OriginalDate,

[CELAMBARASAN]

Hi,

     Its better to use like below

     Date(Date#(OriginalDate,'YYMMDD'),'MM/DD/YYYY') as OriginalDate

Celambarasan