KNOWLEDGE BASE

Date Calculated Fields Return Nulls After Extract Refresh


Published: 18 Nov 2013
Last Modified Date: 21 Jul 2016

Issue

After you refresh a MySQL extract that includes date calculated fields, the calculated fields might produce null values.

Environment

  • Tableau Desktop
  • MySQL

Resolution

Modify the formula to use the following date format: YYYY/MM/DD.

For example:
 
DATETIME( "1969/12/31 "+ 
STR(DATEPART('hour', [<DateTime Field>]))
+
":"
+
STR(DATEPART('minute', [<DateTime Field>])) 
+
":00"

Cause

MySQL expects a date format of YYYY/MM/DD. 

 
Did this article resolve the issue?