How to query data from collection using datetime as filter, I am using DataAPI for the same

I am using Data API (Postman tool) to query records from my collection. But when I am trying to add datetime filter for the same, I am not able to figure out the correct syntax, I tried multiple syntaxes but nothing seems to work.

my Input Query:-


I have to do something like

Select * from Events where pxCommitDateTime < “” And pxCommitDateTime > “”

Please help.

Hello @Priyabrata_Nath ,

Welcome to The MongoDB Community Forums! :wave:

Please check below thread as a similar issue has been resolved there.