Issue with Formatting Date in Make.com Scenario Using Google Docs Template

Hello, I am working on an invoice.

I am unable to change the date format on the invoice.

Check the screenshots.

If anyone has suggestions, I would appreciate any advice.


Your function has to be manually typed out (which should then auto-convert to a block), or you can select the function from the IML panel.

For more information, see the Make Academy.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

@samliew


P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

Can you provide more detailed information? It’s not understood this way. In the videos I watched and in forums with similar issues, it’s always the same.

For the invoice, I want 2024-11-12T14:45:14.000Z to appear as 12-11-2024.

In the Google Doc Template Module, I am writing this in the date field: formatDate({{1.created_at}}; ‘DD/MM/YYYY’), but it still doesn’t appear correctly.

Hello @aon,

Syntax Issue

@samliew trying to suggest Make Academy courses because in the Make when you open that helper dialog you should know how to use it.
It’s a really basic and important thing in Make.
The first and very important thing is that Make functions should be written on specific syntax.
Check these references.

  1. https://www.make.com/en/help/functions/using-functions#using-functions
  2. Transforming Data using Functions - Make Academy

Specific to this Issue.

When you understand how to use functions then you realize that functions are more important when using transform and parse data.
Try this and change the manually added date.
{{formatDate(parseDate("2024-11-12T14:45:14.000Z"); "DD-MM-YYYY")}}

When you paste my created function syntax it shows you the difference.
See this attached screenshot as well.