Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ABAB XSLT Parse ISO 8601 Date with offset to Timestamp

Go to solution
Former Member

‎2017 Nov 27 10:06 AM

0 Kudos
1,248

We get timestamp data in XML as follows:

<creationtime>2017-11-27T03:01:53.593+01:00</creationtime>

How can we transform (XSLT) this to a valid UTC timestamp?

Note, if we chop off the first 14 chars SAP gets a timestamp but it's incorrect because of the missing +01:00

1 ACCEPTED SOLUTION

Go to solution
Sandra_Rossi
Active Contributor

‎2017 Nov 27 11:37 AM

0 Kudos
432

I think there's no standard way to do that -> cf ABAP Documentation asXML - Mapping of Reference Variables and Referenced Objects 7.51

But you can create your own custom XSL method to transform it -> cf SAP Library: additional SAP statements (sap:call-external)

1 REPLY 1

Go to solution
Sandra_Rossi
Active Contributor

‎2017 Nov 27 11:37 AM

0 Kudos
433

I think there's no standard way to do that -> cf ABAP Documentation asXML - Mapping of Reference Variables and Referenced Objects 7.51

But you can create your own custom XSL method to transform it -> cf SAP Library: additional SAP statements (sap:call-external)