DATEPARSE Function Not Available

Issue

When using date functions, DATEPARSE might not be available.

Environment

Tableau Desktop
Live data source connections

Resolution

Use a data extract instead of a live data connection.

Cause

The DATEPARSE function is not available for all data source connections because some of the database's SQL dialect does not support this.

DATEPARSE is available through the following connectors: non-legacy Excel and text file connections, Amazon EMR Hadoop Hive, Cloudera Hadoop, Google Sheets, Hortonworks Hadoop Hive, MapR Hadoop Hive, MySQL, Oracle, PostgreSQL, and Tableau extracts.

DATEPARSE is not supported on Hive variants. Only Denodo, Drill, and Snowflake are supported.

Additional Information

Click here to return to our Support page.

Open a new case

Click here to go to our Support page.

Get detailed answers and how-to step-by-step instructions for your issues and technical questions.

Find and share solutions with our active community through forums, user groups and ideas.

Browse a complete list of product manuals and guides. Available online, offline and PDF formats.

Learn how to master Tableau’s products with our on-demand, live or class room training.

All Support