Forum Discussion
Filter by DateTime in Odata
Hi, I would need to filter by the column "CalendarDateId" in an OData feed, but I can't the filter to work. For example records where CalendarDateId >= 08/01/2022. I've tried several formats and di...
Found the solution, should be written like this "datetime'2022-08-01T00:00:00.000'
Hi Jeanxyz
Due to the size of the data and the fact that it is very slow to do any transformations in Power Query, I would need to filter the data in the Odata -query.
Br, Chris
Found the solution, should be written like this "datetime'2022-08-01T00:00:00.000'