cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Build Apps - Convert Date from OData

ITM_Benedikt
Explorer

Hello all,

Whenever I use a date from an Odata service, it is formatted like this:

With the usular functions in SAP Build Apps, I cannot convert it to any other date format like "dd.mm.yyyy".

As I'm using a standard OData service (API_SALES_ORDER_SRV) I can't change the type of the field to string. Has anyone encountered this problem and can help me?

Thanks

Benedikt

View Entire Topic
navalega0109
Participant
0 Kudos

Hello @ITM_Benedikt ,

 

Use the below function inside formula section to change the format you wish for.

FORMAT_DATETIME_LOCAL(date/time, format)

 Example

FORMAT_DATETIME_LOCAL("2019-07-11T13:06:15+03:00", "DD.MM.YYYY")

Output:

11.07.2019