Share feedback, ideas and get community help

Updated 3 months ago

Date Output Error!!

    1. 28 21:16:03
In the above format, a variable representing the current date and time was inserted into the Google spreadsheet, and the variable value was output in a text block.

It is well inserted in the Google spreadsheet.
However, outputting a variable value causes an error.
Attachments
2024-09-28_9.27.07.png
2024-09-28_9.33.28.png
L
s
B
10 comments
is the type of the cell on spreadsheet actually a date? It might be a text well formatted as a date but only visually
You can change the format in Google spreadsheet.
Attachment
2024-09-28_10.21.15.png
can you test with different formats and see if the issue persists only with the first one
2024-09-28 21:29:00
When specified in the above format, it is output normally
Attachments
2024-09-29_8.43.05.png
2024-09-29_8.47.27.png
This is an error code
Attachments
2024-09-29_8.48.47.png
2024-09-29_8.48.52.png
error code -> return ${year}. ${month}. ${day} ${hours}:${minutes}:${seconds};
normal code -> return ${year}-${month}-${day} ${hours}:${minutes}:${seconds};
(Results) looks normal.
Attachment
2024-09-29_8.54.06.png
In both cases, (Results) appear normal.
That looks odd indeed
Can you create a simple bot flow that reproduces the issue and share it here?
Add a reply
Sign up and join the conversation on Discord