Tableau Output Tool - Dates not posting correctly

[warrenpagel]

After Tableau implemented MFA for all services, I transitioned my Publish to Tableau Server tool to the Tableau Output Tool, but I'm having an issue wherein the new tool is not reading dates correctly. I've tried a variety of troubleshooting options with no success. The following error appears every time I attempt to output anything to Tableau with a date format:

Tableau Output (233) Got an invalid value '2020-05-18' for column "Invoicedate", it must be a Date, Timestamp, datetime, or date instance

The field is formatted as date and is reading correctly as date in both Alteryx and Tableau.

[RobertOdera]

Hi, @warrenpagel 

Consider this in Alteryx after you have completed all the workflow processes AND BEFORE you connect the Tableau Ouput Tool(s).

Use the DateTime tool to convert the Date from String to DateTime (or from DateTime to String) - whichever applies to your use case.

I hope you find this helpful - Cheers!

[warrenpagel]

Thanks for responding. The field does not need to be converted to or from Date as it is already a Date type field. I've already attempted to convert the field from Date to String and back again, as well as using DateTime instead of Date. Same error every time.

[MikeMarandola]

I am having this issue as well. Were you able to fix it?

[warrenpagel]

I was able to work around the issue by simply publishing my datasource with all date fields as strings and then converting them back to dates within Tableau itself. Unfortunately I've not been able to find any solution that allows me to publish fields formatted as dates using this tool.

[MikeMarandola]

Ah unfortunate. I'll proceed for the work around for the time being. Thanks for your help!

[hellyars]

@warrenpagel 

Your work around is a good idea. 

Curious, are you outputting a .hyper file or .tde file?