I want to format my
[Start Time] column as a short date. I created a calculated column and employed the
TEXT() method like so:
=TEXT([Start Time], "MM/DD/YYYY")
However, it appears that this is returning and formatting the UTC value of
[Start Time]. What I want is to display the formatting in the timezone that pertains to the user's experience.
How do I ask the calculated column to take into account the user's timezone (as captured when the field was created)?
If I have a DateTime field set at:
3/21/2017 12:00 AM.
This appears to be stored, however, as:
42814.8333333333 ... which is equivalent to:
3/20/2017 8:00:00 PM UTC.
When I apply the calculated column (above) it outputs:
3/20/2017. Which is not what I want. I want
3/21/2017 ... which should be