When I try insert a date filed in MongoDB it is inserting as null.
actually the date should insert like as follows
"createdDate": {
"$date": "2021-03-09T09:04:52.794Z"
},
but it is inserting as
"createdDate":null
Can some one help me to insert a date filed into MongoDB.
Thanks in Advance.
Hello, can you share your current workflow?
Here is the workflow
{
"nodes": [
{
"parameters": {},
"name": "Start",
"type": "n8n-nodes-base.start",
"typeVersion": 1,
"position": [
160,
280
]
},
{
"parameters": {
"values": {
"string": [
{
"name": "createdDate",
"value": "2019-10-07T18:30:00.000Z"
},
{
"name": "name",
"value": "Adam Smith"
}
]
},
"options": {}
},
"name": "Set",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
310,
280
]
},
{
"parameters": {
"operation": "insert",
"collection": "User",
"fields": "name,createdDate"
},
"name": "MongoDB",
"type": "n8n-nodes-base.mongoDb",
"typeVersion": 1,
"position": [
510,
280
],
"credentials": {
"mongoDb": "mongo-cred"
}
}
],
"connections": {
"Start": {
"main": [
[
{
"node": "Set",
"type": "main",
"index": 0
}
]
]
},
"Set": {
"main": [
[
{
"node": "MongoDB",
"type": "main",
"index": 0
}
]
]
}
}
}It’s working just fine for me. Not sure what might be happening there. Is the date field nested?
Can you share your schema?
The schema is already defined using some other application. And in the mongoDB schema definition, the createdDate property datatype defined as Date type. So its getting inserting as null.
Hi @RicardoE105 actually the date should insert like as follows
"createdDate": {
"$date": "2021-03-09T09:04:52.794Z"
},
but it is inserting as
"createdDate":null
Ahh yes, I tested with a string type. That is why it worked for me. Checking again
Hi @RicardoE105
Any update on this
Ahh yes, had to make some changes to make work. Will send the PR today. We will try to add to the next released.
Ok, added a new option field called “Date Fields”. Set the the Date Fields and it’s gonna be set to a instance of Date. Can you test it locally and provide feedback?
Got released with [email protected]
Thanks a lot @jan for prompt response
Hi,
when I add {{ Object.keys($json) }} as expression into the parameter Fields it shows me as result all fields seperated by “,”.
But not all fields get inserted into the db.
Here is the input:
{
"_id": "68ad2c87d3fc02ef303fa1f3",
"number": "165/2025",
"numberRaw": 165,
"address": "Amt der Kärntner Landesregierung\nStraßenmeisterei Feldkirchen\nSt. Ruprechter Straße 20\n9560 Feldkirchen",
"textAfterTable": null,
"serviceDate": "2025-08-26T00:00:00.000Z",
"invoiceDate": "2025-08-26T00:00:00.000Z",
"deliveryDate": null,
"purchaseOrderNumber": null,
"paymentStatus": "open",
"sendStatus": "sended",
"worktimeDiscountPercentage": null,
"createdAt": "2025-08-26T03:39:51.839Z",
"dataSyncedAt": null,
"isDeleted": false,
"isCancelled": false,
"customerId": "64eb0cc7f51409da724aeb97",
"isReverseCharge": false,
"isMainDateServiceDate": false,
"totalBeforeTax": 624.6700000000001,
"totalAfterTax": 749.604,
"tax": 124.934,
"termOfCredit": 21,
"positions": [
{
"id": 1,
"service": "Messersatz\nMS 12 Stück",
"articleNumber": "251040",
"quantity": 1,
"price": 590,
"discountPercentage": null,
"total": 590
},
{
"id": 2,
"service": "Fracht",
"articleNumber": "100000",
"quantity": 1,
"price": 27.22,
"discountPercentage": null,
"total": 27.22
},
{
"id": 3,
"service": "Arbeitsstunden + Fahrzeit *",
"articleNumber": "100003",
"quantity": 1,
"price": 7.45,
"discountPercentage": null,
"total": 7.45
}
],
"sendStatusChangedAt": "2025-08-26T03:41:08.149Z",
"updatedAt": "2025-08-26T03:41:08.149Z",
"cancelledAt": null
}
Here ist the output that was inserted:
{
"_id": "68ad2c87d3fc02ef303fa1f3",
"number": "165/2025",
"address": "Amt der Kärntner Landesregierung\nStraßenmeisterei Feldkirchen\nSt. Ruprechter Straße 20\n9560 Feldkirchen",
"paymentStatus": "open",
"createdAt": "2025-08-26T03:39:51.839Z",
"isDeleted": false,
"customerId": "64eb0cc7f51409da724aeb97",
"totalBeforeTax": 624.6700000000001,
"totalAfterTax": 749.604,
"tax": 124.934,
"positions": [
{
"id": 1,
"service": "Messersatz\nMS 12 Stück",
"articleNumber": "251040",
"quantity": 1,
"price": 590,
"discountPercentage": null,
"total": 590
},
{
"id": 2,
"service": "Fracht",
"articleNumber": "100000",
"quantity": 1,
"price": 27.22,
"discountPercentage": null,
"total": 27.22
},
{
"id": 3,
"service": "Arbeitsstunden + Fahrzeit *",
"articleNumber": "100003",
"quantity": 1,
"price": 7.45,
"discountPercentage": null,
"total": 7.45
}
],
"updatedAt": "2025-08-26T03:41:08.149Z",
"sendStatus": "sended",
"serviceDate": "2025-08-26T00:00:00.000Z",
"numberRaw": 165,
"id": "68ad2c87d3fc02ef303fa1f3"
}
Missing fields:
invoiceDate, isCancelled, isMainServiceDate, isReverseCharge, sendStatusChangedAt, termOfCredit, …
But its funny because some dates get inserted, others not. Some Strings get inserted others not.
Hey @FabianWassermann create a new topic about your questions, so you can get the help you need.