Facing problem in applying date/time function

Beginner Questions
,
1

:bullseye: What is your goal?

Add the accurate date and time for Paris and New York in the Google sheet with no extra text.

:thinking: What is the problem?

I’m making a scenario in Make where I’m practising date/time functions. I used the formatdate function with the variable now, but facing 2 issues: According to the guidance in Make, there should be a difference of 6 hours in date and time (Paris) and date and time (New York), but my results has same, with no difference. Why? Second, why is the extra text showing after the date and time? How can it be removed? Is there any mistake in the input or in choosing fields? Please write the correct data format for input field for the date/time function with the variable now.

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

image-1785338531542.jpg
image-1785338531542.jpg4096×3072 2.63 MB

3

Hey there,

Can you show screenshots of the functions in Make?

4

Sure, here it is:

IMG_20260729_214331538
IMG_20260729_2143315381920×2560 1.42 MB

5

The second semicolon is wrong. It’s not the function one but just the text string.

6

But in the Make Academy, it says to make sure there is no space between semicolons and the last text?

7

Yeah but looks at the first semicolon then looks at the second one. The issue is not the spaces.

9

Thank you, Mr. Vatov, I got the solution.

10

:bullseye: What is your goal?

Add the accurate date and time for Paris and New York in the Google sheet with no extra text.

:thinking: What is the problem & what have you tried?

I’m making a scenario in Make where I’m practising date/time functions. I used the formatdate function with the variable now, but facing 2 issues: According to the guidance in Make, there should be a difference of 6 hours in date and time (Paris) and date and time (New York), but my results has same, with no difference. Why? Second, why is the extra text showing after the date and time? How can it be removed? Is there any mistake in the input or in choosing fields? Please write the correct data format for input field for the date/time function with the variable now.

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

image-1785338531542.jpg
image-1785338531542.jpg4096×3072 2.63 MB

12

Hello,

Can you show your function in Make? Looks like your semicolon was not properly encoded eg. it is normal character ;, not ; pill.