
Announcements
Hello Community!
I am wondering if there is a way to create a custom DateTime format when I am adding a row into a table. Listed below is a screenshot of the Add a row action and in it you can see that I have referenced certain outputs that from compose actions that reference different values from an excel spreadsheet. Within this spreadsheet there are dates and times for StartTime and EndTime (Ex: 8/24/2023 10:30:27 AM and 12:15:10 PM). Within the same row there is a TimeDifference column that calculates the difference between StartTime and EndTime. It gives its time difference in HH:mm:ss format.
When the row is added into the designated table, the numbers are converted from a HH:mm:ss (Ex: 03:55:22) format into a format I am unsure of. The screenshot of this new format is listed below. Is there a way to customize the DateTime format within the add a row action to ensure that the times from the rows referenced by the compose actions stay in a HH:mm:ss format?
Thank you,
Noah
Hi @Noah100 ,
Please try updating the date format here:
If this was helpful, please mark as a solution.