help me how to implement this function in datastage

[vikramkola]

TO_DATE( '01-07-' || TO_CHAR(PS_D_DAY.YEAR_NUM - 1), 'DD-MM-YYYY' )



help me ,what code should write in transformer stage.

[ray.wurlod]

What are you trying to achieve?

July 1st of prior year?

Without a clear specification we would have to guess, which wastes both our times.

[Kryt0n]

You would have hoped colleagues can provide sufficient guidance on such a request rather than the need to use dsxchange

[chulett]

Looks to be a snippet from this post.