[Bug]: Date queries fail with Extended JSON format - requires JavaScript Date constructor #691
Description
Version
main
App
- Cursor
- Windsurf
- VSCode
- VSCode Insiders
- Claude Desktop
- Other
Affected Models (if applicable)
- Claude 3.5 Sonnet
- Claude 3.7 Sonnet
- GPT-4a
- o4-mini
- Other
Bug Description
When querying date fields using MongoDB's Extended JSON format, queries fail with an "unknown operator: $date" error. The server appears to expect native JavaScript Date objects instead.
Current Behavior (Doesn't Work):
javascript{
"$match": {
"created_at": {
"$gt": {"$date": "2025-10-20T01:02:50.000Z"}
}
}
}
This works:
{
"$match": {
"created_at": {
"$gt": new Date("2025-10-20T01:02:50.000Z")
}
}
}