I am having issues with the date formatter working consistently. I am writing a Square order to a Google Sheets spreadsheet. I am using the date converter to convert my timestamp to a simple date string
Timestamp coming in is closely formatted to YYYY-MMDDTHH:mm:ssZ
Date used in the testing is 2023-04-26T02:14:16Z
Converting this to MM/DD/YYYY
test output is 04/26/2023
When testing this on writing a full row to Google Sheets, the value in the cell is correct at 04/26/2023
When I run a 2nd test, using the same values, no changes, just running the test again, the value is now $45,041.00
What I have noticed is every other time the test is ran, the value gets written as a formatted currency.
When publishing this Zap, and new orders come in, it is doing the same thing.