Ensure date format in Notion field

[Louise_Hare]

Hey everyone,

I am trying to send some data from HubSpot to Notion and am having an issue with date formatting on one of my properties.

The property is in the date format in HubSpot, and Make.com seems to be picking that up.

However, when I try to send that property to a date format field in Notion I am receiving this error-

If I make the field in Notion text format, I am able to receive the date like this

How can I ensure the property is sent to Notion in date format?

Thank you!

[Simo]

Hi Louise - try using the formatDate() function in Make with YYYY-MM-DD. formatDate(date_became_an_sql;YYYY-MM-DD) (just pseudo code for demo, don’t copy-paste)