Desired outcome is UTC time retained in Tableau - aviation data therefore always need UTC.
The Excel column imported into Tableau is formatted as number and represents UTC time:
Excel screenshot of YYMMDDHHMM in UTC or "zulu" time
Problem: Tableau is interpreting this as 24hr time rather than UTC:
Tableau screenshot of tableau's conversion
I think I need a calculated field but haven't been able to find a solution. Is this fix possible? Thank you
A date value (or in your case a date-time value) can be formatted for presentation in several ways, just as in Excel. Changing the format doesn’t affect the underlying value, just how it is presented.
Right click on your field, press format, choose the date format you desire from the format pane on the left margin.
If you don’t think Tableau is correctly converting your string values to date time values, then you can take control of that conversion with the DateParse() function
