KNOWLEDGE BASE

Error "Invalid date" When Connecting to BigQuery Using Custom SQL


Published: 02 Mar 2020
Last Modified Date: 02 Mar 2020

Issue

When using custom SQL to cast a NUMERIC field to STRING, the following error may occur:

The Google BigQuery service was unable to compile the query.
Error Code: 9F80FB23
Invalid date: '01/01/2020'

Environment

  • Tableau Desktop
  • Google BigQuery

Resolution

As a possible resolution, try casting the NUMERIC field to INT64 or FLOAT64 instead of STRING.

Cause

Casting the NUMERIC field to STRING may result in a query for a calculated field that contains the invalid date.
Did this article resolve the issue?