This content has been marked as final.
Show 2 replies
-
1. Re: Does Tableau handle DateTimeOffset types
Andy CotgreaveJan 10, 2012 2:30 PM (in response to jasonsroka)
Hi Jason
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:
DATE(LEFT([Birthdate],10))
Alternatively you could do a CustomSQL connection and convert the field there.
Hope that helps
Andy
-
calculated_date.twbx 9.4 KB
-
-
2. Re: Does Tableau handle DateTimeOffset types
Jens Theisen Jul 5, 2018 4:45 AM (in response to Andy Cotgreave)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.