I have an Excel Power Query to pull information from a custom IDO. I would like to filter the query to only get records where the "ShipDate" is current year. Since Json formats a data/time value as text, I cannot find a way to do this in my IDO query.
(As a temporary solution, I have parsed the ShipDate into a new column and formatted it as a date/time value. This, however, does not limit the number of records my query returns.)
Here is the current query:
