https://community.sap.com/t5/technology-q-a/odata-filter-with-date-time-offset/qaa-p/12467555#M4670430 <P><A href="https://www.odata.org/documentation/odata-version-2-0/overview/" target="test_blank">https://www.odata.org/documentation/odata-version-2-0/overview/</A></P><P>$filter=changeddatetime gt datetimeoffset'2023-10-10T00:00:00Z'</P> Thu, 19 Oct 2023 21:29:08 GMT LuizGomes 2023-10-19T21:29:08Z https://community.sap.com/t5/technology-q-a/odata-filter-with-date-time-offset/qaq-p/12467554 <P>Dear SAP Gateway colleagues,</P> <P>I'm from the <A href="https://sap.github.io/cloud-sdk/" target="_blank">SAP Cloud SDK</A> 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 <A href="https://support.wdf.sap.corp/sap/support/message/2170132188" target="_blank">the response from colleagues</A> maintaining <EM>API_BUSINESS_PARTNER</EM> it seems to not be possible to run the following request:</P> <PRE><CODE>$filter=ValidityStartDate gt datetimeoffset'2025-01-01T00:00:00+09:00' </CODE></PRE> <P>(when ValidityStartDate is a field of type Edm.DateTimeOffset)</P> <P>Can you confirm or deny this assumption?</P> <P>Kind regards</P> <P>Alexander</P> Thu, 06 May 2021 11:52:23 GMT https://community.sap.com/t5/technology-q-a/odata-filter-with-date-time-offset/qaq-p/12467554 former_member129581 2021-05-06T11:52:23Z https://community.sap.com/t5/technology-q-a/odata-filter-with-date-time-offset/qaa-p/12467555#M4670430 <P><A href="https://www.odata.org/documentation/odata-version-2-0/overview/" target="test_blank">https://www.odata.org/documentation/odata-version-2-0/overview/</A></P><P>$filter=changeddatetime gt datetimeoffset'2023-10-10T00:00:00Z'</P> Thu, 19 Oct 2023 21:29:08 GMT https://community.sap.com/t5/technology-q-a/odata-filter-with-date-time-offset/qaa-p/12467555#M4670430 LuizGomes 2023-10-19T21:29:08Z