Reg. Date

[wittyme]

I have the date format from the source like YYYYMM
and I want to change it to YYYY0MM

How to append a 0 in btw. for a column

[ArndW]

What is your field's data type? If a string, then "In.Col[1,4]:'0':In.Col[5,2]" would do the trick.

[agpt]

if this is a date... use MonthFromDate and YearFromDate function to get values of yyyy and mm and use the function which arndw suggested.

[ray.wurlod]

Not quite; MonthFromDate() returns a TinyInt which may only have one digit. That would need to be padded.

Code: Select all

YearFromDate(InLink.TheDate) : Right("000":MonthFromDate(InLink.TheDate),3)