Hello!
I need to convert date and time data from various time zones to GMT-5 and input it into Google Sheets. While testing, the data conversion works correctly, but when processing actual contact data, there is a 17-hour discrepancy. When I check the Zap history, I see that the Data in is incorrect, showing a discrepancy of 9 hours. What could be causing this issue?
Hi
For the Input, use the UNIX timestamp below which has a UTC time zone. (help)
Then set the From Format to be: X
That indicates a UNIX timestamp format.
Some apps require a UNIX-formatted timestamp.
| Timestamp | Command |
| UNIX | {{zap_meta_timestamp}} |
ExampleIf a Zap runs on July 31, 2025 at 9:24:51 AM UTC, the UTC timestamp will output: 1753953840.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.