How to convert DB2 date format of CYYMMDD to DD/MM/YYYY on load

[martin_hamilton]

Hi I am connecting to a DB2 using SQL and the dates are being returned in the format CYYMMDD and I wish to convert to DD/MM/YY.

Is there a standard to do this?

Thanks

Martin

[martin_hamilton]

Hi Tony - this works if I load from a file which has the same format but not via an ODBC connection using SQL. It doesnt like the expression Date# for some reason.

thanks

Martin

[ToniKautto]

My suggestion would be that you load the field without format, and confirm if it comes in as a text or number. Then adapt the format function accordingly.