KNOWLEDGE BASE

DATE Function Returns NULL in Google Big Query


Published: 21 Sep 2016
Last Modified Date: 26 Sep 2016

Issue

When using Google Big Query, the following type of DATE function DATE("1/1/1970") returns NULL. 
 

Environment

  • Tableau Desktop
  • Google BigQuery

Resolution

Use "-" instead "/" as a separator. For example, DATE("1970-01-01")

Cause

Google BigQuery expects "YYYY-MM-DD" format as a date format.
Did this article resolve the issue?