Hi Makers!
I am writing various pieces of data to google sheets and formatting dates is causing me lots of headaches!!
The channelling things is that I have solved the formatting issue a number of times, but once I save my scenario and then go back and run it a day later, the date issues seem to pop up again, or it return the date in another completing random format.
Example 1:
My API returns the following date and time format: 2025-05-03 15:05:05
I used the following expression:
{{formatDate(parseDate(api.date; “YYYY-MM-DD HH:mm:ss”); “DD/MM/YYYY HH:mm”)}}
It initially worked and returned:
03/05/2025 15:05
After saving and reopening it returned:
20/05/2003 15:05
I decided to strip all date formatting and simply insert the date as it comes from my API to make it easy.
After doing this, some lines of data are correct and then in others it simply returned the date in the following format: 05/03/2025, which is very odd as there is no date formatting.
I feel like I am going crazy as I am solving issues, they work, and then days later the solution does not work, and it is broken again.
It is very hard to schedule recurring scenarios knowing these issues keep recurring.
In this case the API is stable and returns the same date format each and every time.
Would love to hear any suggestions to how to ensure stability.
