1 Reply Latest reply on Jun 17, 2016 11:39 PM by Dmitry Chirkov

    Blank or Null In Date Fields

    Christopher McKinnish

      I have a data set that includes change date/times.  In this occasion I need to display the details in the workbook

       

       

      My date fields are actually conversions from a interger date format of CYYMMDD (Century, Year, Month, Day).  I tried wrapping the date converstion in a formula to display null or blank, but still tableau converting to the date you see 11/30/1899

       

       

       

      The problem is as you see in the last column, the field is null or 0, and therefore returning a default date, which is misleading.  Where there is a value, I need to display it, else blank.

       

      Anyone have a suggestion how to hide this.  I've tried IF, and Case formulas to no evail

       

      Thanks / Chris