Originally posted by: SystemAdmin

is there a trick to get this to work in 7.5? I have an input date format of DD MON and the output is formatted as YYMMDD. Currently I am getting ## for the year.

Thanks.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: SystemAdmin

Not sure about tricks but assuming you want to always use the current year (unless you have some other source for YY), in your output rule use the following:-

= TODATETIME (Input + RIGHT (TEXT ( CURRENTDATE () ), 2) , "{DDMONYY}")

Where Input is your DDMON field. Define your output field as format YYMMDD or YYMMDDHHMMSS etc whatever you need.

Regards

Tarun
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

or....

TODATETIME (Input + fromdatetime( CURRENTDATE () "YY") )
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange