I am using JSON and mongodb shell helper functions to generate the report from the UI.I tried to convert the date to String but the Date is defined in MongoDB Database as ISO Date and I am getting Parsing errors . Can any one help me how to pass the Date in UI.Below syntax which I have tried
"ReportQuery":[{
"$match":{
"$and":[
{"system":"color"},
{"Date":{$gte":
$dateFromString":{
"dateString":"#DATE#",
"format":%Y%m%d"
}
}
]
}
}
New contributor
Shirisha is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.