3687517 - Error when filtering by Date with Custom OData Service in SAP Analytics Cloud

An issue arises when applying a filter on a Date field in SAC, causing the query to fail.
- Error message: unexpected program error.

SAP Analytics Cloud 2025.14.17 

1. Open Analytics Cloud
2. Go to the modeler
3. Create a new model
4. Try to consume the Custom OData query

The formatting in your filters needs to be adjusted to align with the correct format. For example, the datetimeoffset format should be updated as follows: 

• datetimeoffset'2020-10-07T00:00:00Z' (correct format)

• datetimeoffset'2025-10-01T00:00:00-00:00' (incorrect fomat)

The full string would look something like:

• $filter=CreatedOn gt datetimeoffset'2020-10-07T06:59:59Z' 

Please note that the values and dates in this example are placeholders, so you may need to modify them according to your specific requirements. 

This edit must be done directly in the source system responsible for generating the OData query being consumed in. None of these steps are done within SAC.

SAC, OData, CRM, AP, Custom, import, filters , KBA , LOD-CRM-INT-API , OData API (C4C Only) , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem