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
Create a new calculation like this and use that in the viz:
IFF( YEAR([Change Date]) < 1900, NULL, [Change Date] )
where [Change Date] is your existing calculation without IFNULL.