# \[FIXED\] Converting an End date to text **URL:** \ **Category:** Bugs & Issues\ **Created:** [January 13, 2021, 10:25pm UTC](https://community.fibery.io/t/fixed-converting-an-end-date-to-text/1302 "2021-01-13T22:25:54Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\ **Post date:** [January 13, 2021, 10:25pm UTC](https://community.fibery.io/t/fixed-converting-an-end-date-to-text/1302/1 "2021-01-13T22:25:54Z")
If I create a Date field with Start and End dates, when I use the ToText function on the End date: `ToText(Date.End)` I don’t get what I expect, but the next day instead. i.e. the ToText function will return the 14th January for an End date set to 13th January. I imagine that it’s possibly because Date fields with Start and End dates are internally stored as running from midnight _in the morning_ of the first day, to midnight _in the evening_ of the last day, if you know what I mean. Or it’s just a mistake :-/ Either way, it’s not what I would expect/hope for. ---
**Author:** ![Polina\_Zenevich](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/polina_zenevich/32/480_2.png) [@Polina\_Zenevich](https://community.fibery.io/u/Polina_Zenevich)\ **Post date:** [January 15, 2021, 8:24pm UTC](https://community.fibery.io/t/fixed-converting-an-end-date-to-text/1302/2 "2021-01-15T20:24:19Z")
Hi, Chris! That is definitely a bug, we are struggling to fix now 😓 Hope next week will find the solution and will fix that! ---
**Author:** ![mdubakov](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/mdubakov/32/10_2.png) [@mdubakov](https://community.fibery.io/u/mdubakov)\ **Post date:** [December 15, 2022, 2:47pm UTC](https://community.fibery.io/t/fixed-converting-an-end-date-to-text/1302/3 "2022-12-15T14:47:26Z")