Need to filter your odata query and only have the datetime value to work with if your format looks like 2018-12-31T000000 Allows filtering, skipping, ordering, expanding, and selecting only N elements (with top) 0) works fine with Report Filter (UI) A possibility to filter the records displayed on the UI; a pure UI feature not. Once that happened, converting the column to DataTime applied the UTC offset as expected even for datetimes where daylight saving was involved.
Search Odata Filter Query Datetime. . When filtering, the UI component reverts an entered date-time value to a string based on the dateSerializationFormat property's value and passes the string to the ODataStore for further processing As we all know, oData is an open standard for formatting queries to web services Additionally, you can use the full string provided in a DateTime column (depending on.