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
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).
Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
The OpenJS Foundation | Terms of Use | Privacy Policy | OpenJS Foundation Bylaws | Trademark Policy | Trademark List | Cookie Policy