492314_en-US

liliconcom

transform column

Hello everyone, I have a problem when I want to transform this column into a date. I transform it in Numeric then in date but when I transform it in date the year becomes 1904 and I don't know why?

 

 

Advanced Statistical ModelingData Blending and CleanupWindowsRe: transform column

You could try creating a formula column with Informat() and then format that as you want. If the start value isn't character add Char() around the column reference

Informat("20210408", "YYYYMMDD");

Informat(Char(:ColumnToConvert), "YYYYMMDD");