Converting an End date to text

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.

1 Like

Hi, Chris!
That is definitely a bug, we are struggling to fix now :sweat:
Hope next week will find the solution and will fix that!