TimeZone values should be entered in HHMM format

[Herman_Mantilla]

Hi, I need to add the date in HHMM format to a Google Sheets, but I don’t know how to make that configuration in make.com so that it passes the format that way, does anyone know how to do it?

I’m passing a screenshot so you can see what I want to do, and this would be the format with which I would like make.com to place the date on the sheet

Format Date: 2023-05-17 03:27:00

Thank you very much in advance!

[samliew]

Welcome to the Make community!

According to the Tokens you can use to format a date variable, you can use HHMM.

e.g.: formatDate({{now}}; "HHMM")

[Herman_Mantilla]

Hi, I did it that way, if I do a test if it passes the format as I want, but when everything happens automatically the date does not pass in this format, what could be the problem?

[Herman_Mantilla]