Update objectId or date type on MongoDB

Questions
1

Describe the problem/error/question

I was able to make it work to add an employers to MongoDB with all fields I needed but for 2 of them is adding them as strings and Im not able to convert their data type to an objectId and date type.

What is the error message (if any)?

No error but as I shared in the image below both fields are being added as string and I can’t change that so far

Please share your workflow

Share the output returned by the last node

image
image638×709 46.3 KB

Currently, it add on MongoDB investmentStageID and lastFundingRoundAnnouncedDate as strings but I want to change data type to objectID and date.

Information on your n8n setup

  • n8n version: 1.76.4
  • Database (default: SQLite): MongoDB
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): cloud
  • Operating system: Windows
2

There’s a Date Field option in the MongoDB node, have you tried that for the date field?

3

Thank you it works!

image
image695×572 11 KB

4

nice :slight_smile: always good to see all options :star_struck: