Help with capturing form submission date & time in New York timezone

:bullseye: What is your goal?

I want my form to capture the exact date and time when a user submits it, in New York timezone, in separate fields for date and time.

:thinking: What is the problem?

When I try to use the now function, it doesn’t register at all once I add the parentheses. It doesn’t show the correct time or timezone. My Make account is set to New York time, but the function doesn’t work as expected.

:test_tube: What have you tried so far?

I tried using:
{{formatDate(now; “MM/DD/YYYY”; “America/New_York”)}}

…but as soon as I add the parentheses for now(), it doesn’t read the function at all. I’ve also tried using formatDate with different formats and timezones, but it still doesn’t return the correct New York time.

:camera_with_flash: Screenshots: scenario setup, module configuration, errors

You can use this expression in the field: {{formatDate(now; "MM/DD/YYYY HH:mm”; “America/New_York”)}}

In the Make.com expressions wizard:

Search for and tap formatDate then click inside the parentheses then search for and tap now then space then manually type "MM/DD/YYYY HH:mm” and space then type “America/New_York”

Sample output: 12/04/2025 13:27

Note: Please do not copy & paste the code directly into the field. Follow my instructions above.

Let me know how it goes!