I am having an issue with the Formatter's Date / Time feature in one of my Zaps. The Zap is designed to create a new row in a Google Sheets spreadsheet every time a certain trigger event happens. I added a step with the Formatter by Zapier to generate a timestamp of the current date and time for each new row.
In the Formatter setup, I have used 'Now' as the input and 'YYYY-MM-DD HH:mm:ss' as the 'To Format'.
However, I've noticed that even though the date is correct, the time always remains the same and does not reflect the current time when the Zap runs.
Best answer by ken.aView original