I need to Remove 'T' from Date & Time structure

[praveenreddy_bk]

Hi

Convert from YYYY-MM-DDTHH:MM:SS+HH:MM to DDMMYY

I need to remove T from this structure ,

Thanks in Advance

[former_member181962 · Accepted solution]

Use the replace function .

It will ask for three arguments.

1) Pass the source string.

2) Pass T

3) Pass "" (Space)

Regards,

Ravi

[praveenreddy_bk · Accepted solution]

Ravi, Can U give me screen shot for this

Thanks in Advance

[vijay_b4]

Hi Praveen,

In the node functions, we have replace function...using that you can remove the T.

or

use node function -Date transformation and specify your input date format and your output date format.

input format - YYYY-MM-DDTHH:MM:SS+HH:MM

output format - DDMMYY

and make sure your input date should be in this format YYYY-MM-DDTHH:MM:SS+HH:MM else it through an error saying unable to convert.

Thanks & Regards,

Pragathi.

[Former Member]

Hi,

In the message mapping, you can do this with the DateTrans function.

[Former Member]

Hi,

you can use the substring function to get YYYY-MM-DD and then use the format / date function to achive DDMMYY in mapping.

Regards,

Kai