What do you want to see in Tableau? It's already Date-Time in tableau as far as I can tell.
Hi Joe. I want Tableau to display the time in hh:mm AMPM format -- same as I had it in Access. I do not understand why Tableau is changing the format to date/time. Is there a workaround for this?
You can format your date-time field to have a default format of anything you want.
Then you can select "Custom" at the bottom of the list of stock formats and create your own format like this:
Depending on your data source, Tableau will apply that as the default wherever you use that field. But for me, I fond that it doesn't do that for TDE data sources, and therefore I just make a copy of the TDE field as a calc, and then apply the formatting to the calc, and Tableau is happy to oblige me on that formatting wherever I use the calc. The underlying date-time value still prevails in the table, of course, but wherever I use the field for display only the date-time portion gets displayed.
That worked. Thanks!