I have JSON in following format:
{
"dateFrom": "10 Apr 2020",
"dateTo": "10 Jan 2021",
}
Now how can I sort or filter on date range using shell or Compass?
Basically i want function which can convert it into real date.
Pls send query. It will be helpful.
note i do not want to use aggregation.
yours sincerley