I discovered an strange behavior when I try to display a date/time in an other format within an calculated column.
The formula of the calculated column is:
this transforms the value of the column
End Time (e.g. 9/4/2016 11:59 PM) to 04‑Sep‑16.
The magic comes in when I set the
End Time to an "All Day Event" (due to its an calendar entry). The exact same date/time combination (e.g. 9/4/2016 11:59 PM) gets converted to 05‑Sep‑16 - which is obviously wrong.
Any ideas why this is happening and how to avoid this conversion error?