Converting date using PI mapping function

[Former Member]

Hi,

In need to convert following date '20130708' (YYYYMMDD) into '2013-07-08T00:00:00+05:30' format in PI mapping.

Is it possible to convert using PI mapping functions.

If Yes then how?

If No then is there any other method by which conversion can be done?

Thanks & Regards,

Vinit.

[Former Member]

Hi Vinit,

You can use this mapping.Here,I am assuming 08T00:00:00+05:30' this as fixed value since you have not mentioned anythings.

Output:-

Please let me know if you this ok with you.

Regards,

Abhi

[Former Member]

Hello Abhinav/Hanee,

I am just trying to understand apart from posting screenshot what extra information is there in ur reply becoz whatever u have posted has already been shared above?

IMO it's against SCN Rules of Engagement. So please don't take it otherwise and try to avoid posting reply which has already been shared in the same thread.

Thanks

Amit Srivastava

[Former Member]

Hi Amit,

Hehe sometimes a screenshoot is helpful and Abhinav uses a constant, this is not at elegant way but finally Vinit will be who takes the option that he considers better. However, i understand that the answers are very similar.

Regards.

[Former Member]

Hi Amit,

When I was posting my solution,I saw only Question posted so I open the thead and posted my solution.Might be someone else was also posting the solution in the meantime.

But I understand,solutions are very simmillar.So,I will try to keep this in mind in future.

Regards,

Abhi