I am trying to filter queue items in the Get Queue Items activity based on today’s date, but I am getting the following error:
Get Queue Items: Invalid OData query options. Error code: 1000
I tried multiple approaches including:
system date format
the format mentioned in the activity tooltip
full datetime values
date with and without time
UTC and local time formats
However, the same error still appears.
In the screenshot attached, I have highlighted the field where I am entering the date filter.
Could you please help with the correct OData date filter syntax for Get Queue Items or suggest how to filter queue items based on today’s date without getting this error?
Please Note: - The activity works fine without any date filter criteria.
The Get Queue Items activity does not support date-based filtering using From/To or CreationTime.Adding any date value results in an invalid OData query (Error 1000).
The correct approach is to retrieve the queue items first and then filter them in the workflow using CreationTime.Date = Now.Date, or use the Reference field if it contains date information.
If solution works for you please mark as solved or let us know if u still face issue