Products connection query date filter suddenly getting INTERNAL_SERVER_ERROR

Retired Boards Appdev Graphql Basics And Troubleshooting
4

Well, it appears that the issue may be more specific to dates with times.

When running a query against orders, based on a specific time..

This works correctly:

created_at:>'2023-12-12T22:45:00+0000' AND created_at:<'2023-12-14T22:30:00+0000'

This does not return correct orders (no quotes):

created_at:>2023-12-12T22:45:00+0000 AND created_at:<2023-12-14T22:30:00+0000

But of course, for products, the query with quotes that should work correctly is getting an INTERNAL_SERVER_ERROR..

So… should this actually work for products? or is there a different/correct way to use date filters that include time and timezone?

I want to also re-emphasize that the reported issue related to product query just suddenly stopped working. We have customers who have had automations running for months without issue…