How to parse Date from Notion to YYYY-MM-DD

How To
1

Dear all,

The following is the date info passed from Notion to Make webhook:

            "Date of Birth": {
                "id": "kUP%5D",
                "type": "date",
                "date": {
                    "start": "1980-01-13",
                    "end": null,
                    "time_zone": null
                }

I have to map this date to the Birthday field in MailerLite which is YYYY-MM-DD. I have tried a number of ways but all failed.

Could anyone share some light?

Thank you so much!

Best regards,
David

2

Hello David,
If you map the “start” value, that seems to be already formatted in YYYY-MM-DD - but in case that doesn’t work, you could use the “parseDate()” function like so:

parseDate({{dateOfBirth.date.start}};YYYY-MM-DD)

*replace {{dateOfBirth.date.start}} above with the “start” value mapped from your Notion module output

4

Hi Simo,

Thanks heaps. I resolved the issue by using get(), which is designed to handle nested objects. All good.

Best regards,
David

1 Like