2 Replies Latest reply on Jul 5, 2018 4:45 AM by Jens Theisen

Does Tableau handle DateTimeOffset types

jasonsroka Jan 10, 2012 12:17 PM

I have a table I'm reading from in tableau and I've been struggling with why some key fields don't seem to be picked up in the data export, in particular a Date-Of-Birth field.

The one thing that I see in common with the fields that I've identified are not being uploaded by Tableau is that they're all DateTimeOffset types (e.g. "1981-03-17 00:00:00.0000000 -05:00").

Does Tableau not handle DateTimeOffset fields? Are there any known workarounds to get it to load the data, even if it has to drop the timezone offset in the process (i.e. truncate it to a DateTime type)?

1. Re: Does Tableau handle DateTimeOffset types

Andy Cotgreave Jan 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
Like Show 0 Likes(0)

Actions
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.
Like Show 0 Likes(0)

Actions

Go to original post

Incoming Links

Re: custom SQL query - missing fields after change and refresh

Tableau Community Forums

Does Tableau handle DateTimeOffset types

1. Re: Does Tableau handle DateTimeOffset types

2. Re: Does Tableau handle DateTimeOffset types

Actions

More Like This

Incoming Links