cancel
Showing results for 
Search instead for 
Did you mean: 

OData filter with date time offset

0 Kudos

Dear SAP Gateway colleagues,

I'm from the SAP Cloud SDK team that develops generic and generated OData clients for Java/JavaScript applications. We are wondering whether "offsets" in date time are supported in OData filter expressions when accessing the Gateway. Given the response from colleagues maintaining API_BUSINESS_PARTNER it seems to not be possible to run the following request:

$filter=ValidityStartDate gt datetimeoffset'2025-01-01T00:00:00+09:00'

(when ValidityStartDate is a field of type Edm.DateTimeOffset)

Can you confirm or deny this assumption?

Kind regards

Alexander

Accepted Solutions (0)

Answers (1)

Answers (1)

LuizGomes
Participant
0 Kudos

https://www.odata.org/documentation/odata-version-2-0/overview/

$filter=changeddatetime gt datetimeoffset'2023-10-10T00:00:00Z'