Help with DateTrans function YYYY-MM-DDTHH:MM:SS

[former_member742586]

Hi Folks,

I have a req where the input date format yyyy-dd-MMTHH:mm:ss should be to convert MM/dd/yyyy.

I am using the datetrans function to achieve this..but its failing in pi

ex:<mo:EventTimeStamp>2014-12-03T14:16:20</mo:EventTimeStamp>

but it fails with runtime error Illegal pattern character 'T'

Can anyone help me how to achieve this ?if there is any udf ,please post me here

Regards,

Kalyan

[giridhar_vegi · Accepted solution]

Hi kalyan,

               Do the mapping as specified below.

Thanks

Giridhar

[engswee · Accepted solution]

This solution by Giridhar is a possible solution too.

But you might want to learn why your earlier config was not working, when it is really possible for it to work. It might come in handy in the future when you have a similar input but your output requires the HHmmss part as well.

You know what they say about giving someone a fish and teaching him/her how to fish.

[former_member742586 · Accepted solution]

Hi Giridhar,

Your solution worked in my mapping..Thanks for your help..

Regards,

Kalyan