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

MongoDB Atlas App Services & Realm Atlas Data API
1

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:-

{
    "collection":"Events",
    "database":"PDC",
    "dataSource":"PDCCluster",
    "filter":
    [{"pxCommitDateTime":{&lt:ISODate("2020-04-17T08:50:15.000+00:00")}}]
}

I have to do something like

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

Please help.

3

Hello @Priyabrata_Nath ,

Welcome to The MongoDB Community Forums! :wave:

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

Regards,
Tarun