Mail Date to Notion problem

How To
,
1

Hello,

I would like to automate the retrieval of information when I send an invoice email and transfer it to Notion. When I receive an invoice email, the date appears in this format: Thu, 20 Mar 2025 08:00:41 -0700.

I want to send this date to a Notion database, but the relevant column (“Réglé en”) is a Relation, not a classic date. In Notion, months are recorded as pages with a format like “Jan 2024”, “Mar 2024”, which allows grouping multiple invoices under the same month.

How can I convert the date extracted from the email into a compatible format and send it correctly to this Relation column? Is there an adaptation solution to set up in Make or Notion to facilitate the exchange between the two?

Thank you for your help!

3

Hi @william_desse and welcome to the Make Community!

Have you looked at the formatDate() function?

Something like:

formatDate(now; MMM YYYY)

could do the trick.

Here are the details:

https://www.make.com/en/help/functions/date---time-functions

L