Tableau doesn't handle the DateTimeOffset type. However, you could quickly create a calculated field to truncate the field. I've attached an example which uses the following calc field:
Alternatively you could do a CustomSQL connection and convert the field there.
Hope that helps
calculated_date.twbx 9.4 KB
DateTimeOffset is the recommended date-time type in Microsoft Sql Server and related technologies.
Despite the workarounds, it's a major bummer that this doesn't work properly out of the box.