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'
Anonymous It looks the dateIDs are already recognized by Power BI as dates, can you filter the date column in Power query?
If that doesn't work, you will need to format the dateID into correct format before you can filter the dates.
step 1. convert date type to Text, user Transform-replace query to replace ' 0.00.00' to blank
step 2. aftet that you should have the value in date format, select the whole column, right click and choose change type- using local, depending on the time format setup in your computer, you need to choose Date - English (United Kingdom) or English(United States)