Conversion of specific time format to Datetime variable

[Former Member]

Hello,

I am using SAP MII 15.1

I am receiving timestamp in following format in XML form as below -

20171206T070000.000

I would like to convert it into standard Datetime datatype like below-

2017-12-06T07:00:00.000

I am trying to find if standard expression editor functions in link editor can help, but could not find so far.

Kindly advise.

Thanks in advance.

[former_member185280 · Accepted solution]

You should be able to do it with the dateformat() function:

dateformat("20171206T070000.000", "yyyyMMdd'T'HHmmss.SSS", "yyyy-MM-dd'T'HH:mm:ss.SSS")

Here is a link to the data and time formats in the MII help:

https://help.sap.com/viewer/d70c3ac3566b41dd896cd7cecc94e14a/15.1.6/en-US/4cc6a33de8d47181e10000000a...

Regards

Christian

[Former Member · Accepted solution]

Thank you ! It worked.. 🙂