# Did Microsoft change how it shows the date?

**URL:** <https://forum.dynamobim.com/t/did-microsoft-change-how-it-shows-the-date/28834>\
**Category:** Uncategorized\
**Created:** [November 23, 2018, 9:57am UTC](https://forum.dynamobim.com/t/did-microsoft-change-how-it-shows-the-date/28834 "2018-11-23T09:57:28Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![PauLtus](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/paultus/32/48502_2.png) [@PauLtus](https://forum.dynamobim.com/u/PauLtus)\
**Post date:** [November 23, 2018, 9:57am UTC](https://forum.dynamobim.com/t/did-microsoft-change-how-it-shows-the-date/28834/1 "2018-11-23T09:57:28Z")

</div>

From yesterday unto today, one of my Dynamo scripts stopped working. When tracing back the problem, I found the name of the excel file I created (which it creates based on the current date) suddenly had a lot of extra stuff in there, including the time, which I all didn’t want.

Checking back, I noticed that the time and date didn’t split properly so the string for the name wasn’t properly being created. Looking at the code I noticed that it was trying to split the string created from the date by looking at the placement of “-”, but saw the date was now being split up with “/” as well as switching the day and month

Simply put:

I expected the date to be read like `23-11-2018 10:52:02` (as it did previously) but it ended being read as `11/23/2018 10:52:02 AM`.

I’m not in a different version of Dynamo, but there was a windows update overnight.

It’s not an issue to change it to fit current way Dynamo reads it, but I can’t have it changing every now and then as other people are supposed to be able to use this without my help.

Anyone knows what might have happened?

---

<div class="post-metadata">

**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\
**Post date:** [November 23, 2018, 10:17am UTC](https://forum.dynamobim.com/t/did-microsoft-change-how-it-shows-the-date/28834/2 "2018-11-23T10:17:59Z")

</div>

Hi @PauLtus

It doesn’t matter what it shows you can always use any format by using Date.TimeFormat node:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/7/9/79b8b344f361b5a5c6a1dfda25b265837692b391.png)

---

<div class="post-metadata">

**Author:** ![PauLtus](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/paultus/32/48502_2.png) [@PauLtus](https://forum.dynamobim.com/u/PauLtus)\
**Post date:** [November 23, 2018, 10:21am UTC](https://forum.dynamobim.com/t/did-microsoft-change-how-it-shows-the-date/28834/3 "2018-11-23T10:21:31Z")

</div>

Well, that’s exactly what I’m looking for!

Didn’t know that existed.

---

<div class="post-metadata">

**Author:** ![Tomasz](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/tomasz/32/66785_2.png) [@Tomasz](https://forum.dynamobim.com/u/Tomasz)\
**Post date:** [November 23, 2018, 11:05am UTC](https://forum.dynamobim.com/t/did-microsoft-change-how-it-shows-the-date/28834/4 "2018-11-23T11:05:21Z")

</div>

See this for reference:  
[https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings](https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings)

---

<div class="post-metadata">

**Author:** ![PauLtus](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/paultus/32/48502_2.png) [@PauLtus](https://forum.dynamobim.com/u/PauLtus)\
**Post date:** [November 23, 2018, 11:41am UTC](https://forum.dynamobim.com/t/did-microsoft-change-how-it-shows-the-date/28834/5 "2018-11-23T11:41:54Z")

</div>

To be honest that’s all a bit much for me to understand.

Thanks anyway.
