# Problems exporting date and time

**URL:** <https://discourse.nodered.org/t/problems-exporting-date-and-time/76911>\
**Category:** General\
**Created:** [24 March 2023 19:55 UTC](https://discourse.nodered.org/t/problems-exporting-date-and-time/76911 "2023-03-24T19:55:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Haiker69](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/haiker69/32/68779_2.png) [@Haiker69](https://discourse.nodered.org/u/Haiker69)\
**Post date:** [24 March 2023 19:55 UTC](https://discourse.nodered.org/t/problems-exporting-date-and-time/76911/1 "2023-03-24T19:55:19Z")

</div>

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](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/c/7cad9d716cb9e9d0561ab7fb8cc0b4b1b2290ef1.png)

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/7/d736553d4533d84e64ec7d38954a0c9e190c3f71.png)

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [24 March 2023 22:21 UTC](https://discourse.nodered.org/t/problems-exporting-date-and-time/76911/2 "2023-03-24T22:21:54Z")

</div>

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).

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [23 May 2023 22:22 UTC](https://discourse.nodered.org/t/problems-exporting-date-and-time/76911/3 "2023-05-23T22:22:13Z")

</div>

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