DSXchange

Would like to put the code below in a transformer in a PX job, but it won't compile. Where do I need to place this code in a PX job?

Thanks

Oconv(Iconv(InLink.TheDate, "DMDY"), "D-YMD[4,2,2]")

Hi,

as far as i know this is a server function and won't work in a PX transformer. possible workarounds are described in this thread:

viewtopic.php?t=135221&highlight=oconv

by the way i found a 6 year old developerworks post from ray, where he suggested the questioner to "roll his own one".

http://www.ibm.com/developerworks/forum ... &tstart=45

BR


Werner

There's no burning need for those functions in a PX job, as there are perfectly acceptable String/Date handling functions already available. You just need to 'convert' one to the other.

BASIC Code wrote:Oconv(Iconv(InLink.TheDate, "DMDY"), "D-YMD[4,2,2]")

PX Transformer Code wrote:DateToString(StringToDate(InLink.TheDate,"%mm-%dd-%yyyy"),"%yyyy-%mm-%dd")

Thanks Everyone. I'll roll one with this and let you know how it goes.