What is your goal?
Add the accurate date and time for Paris and New York in the Google sheet with no extra text.
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.
Screenshots (scenario flow, module settings, errors)