AnsweredAssumed Answered

Date Time Format Assistance

Question asked by codylv7 on Jun 27, 2018
Latest reply on Jun 27, 2018 by codylv7

Hello!

 

I am hoping someone here can help me with a Date Time format/parse.  I am pulling in data from an OData REST endpoint, and the timestamps that come in aren't all in the same format, which is causing the conversion in mapper to fail.  I am mapping to a SQL Server DB, column is datetime2 format.  The dates come through in the following formats:

 

  • 2018-02-07T00:00:21.5033333Z
  • 2014-06-24T22:39:20.91Z

 

Why it isn't consistent baffles me, you would think they would want to be.  I have tried so many different masks, scripts, etc. Any assistance is appreciated.

 

Cody-

Outcomes