You are using an OData query for a report which contains a date time field. You would like to filter on it, however when you check the metadata for this report, you notice that the field has an Edm.String format. You cannot filter on it.
SAP Cloud for Customer
- SAP Business ByDesign
Currently, date time fields are handled as Edm.String fields, which is correct. Additionally as per the product documentation, filtering on date time fields is not supported.
We would recommend to use a date field for filtering.
For further information on how this feature is designed and how to set up your OData query correctly, please see the following blog:
OData, date-time, DateTime, $filter, edm, reporting, business analytics, cannot filter, filter not possile, $select not working , KBA , report selection , string , edm , odata filter , datetime , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To