Problems exporting date and time

General
1

good day community

I have a simple flow, from a form node I have 4 fields, in the dashboard it works well, the date and time are well appreciated and from there I export it and save the values in an excel file, but in the excel file arriving in another very different format as I correct it, I hope you can guide me, greetings and thanks

image

image

2

That is expected. JavaScript dates and times will be converted to ISO8601 format. The time looks odd because you only got time and ISO format is the number of ms since 1st Jan 1970.

Combine the 2 to get a date/time. And watch out for timezone differences. The stored date/time is always in UTC (AKA Zulu, AKA GMT).

3

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.