JSON Date Format

[Former Member]

Hi,

We have a Gateway service with some date fields (ABAP datatype DATS converted to Edm.DateTime or Edm.DateTimeOffset).

When service is called with output format JSON, date values are represented in MicrosoftDateFormat format (e.g. "/Date(1448841600000)/").

In contrary, when output format is XML, dates are in ISO-8601 format: YYYY-MM-DDThh:mm:ssTZD (e.g. 1997-07-16T19:20:30+01:00).

Is there any way to change the JSON date format, either in field level or system level?

[AshwinDutt · Accepted solution]

Hello Shai,

Current formats which you are getting are the standard ones.

If at all you want to send back the Date value in some other format, then you will have to use Edm.String in GW level and send back the date value with the desired format from DPC.

Regards,

Ashwn

[Former Member · Accepted solution]

I was afarid of it.

Thanks, anyway.