When configuring to pull from a Document Cache component, and one of the indexed fields is a date field, you may be able to retrieve any documents.
When configuring the Document Cache Shape to index by a Date Field, the indexed Date is essentially stored within a specific Date Format, that may not match your desired format. By default, this format is: yyyyMMdd HHmmss.SSS
There is currently a defect in our development backlog, and it will be prioritized by our product management team for a future release.
The defect number is: PLAT-11218
To retrieve documents when using an index of a date field, you'll need to configure query date to be in the yyyyMMdd HHmmss.SSS format.