Replace Null Dates With Blanks in Tableau

Missing dates that display as "null" in a Tableau worksheet are an eyesore. Want a quick solution? Check out this video for a couple ideas on how you can turn those nulls in to less obtrusive blanks. Simple IF ISNULL([Order Date - With Nulls]) THEN "" ELSE STR([Order Date - With Nulls]) END Advanced IF ISNULL([Order Date - With Nulls]) THEN "" ELSE DATENAME('month',[Order Date - With Nulls]) + " " + DATENAME('day',[Order Date - With Nulls]) + ", " + DATENAME('year',[Order Date - With Nulls]) END Connect with us: •Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 •Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumber-15678294163 •Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter •Follow Eric on LinkedIn: https://www.linkedin.com/in/eric-parker-37513249/ Resources: •Example Tableau Workbook: https://public.tableau.com/app/profile/eric.parker/viz/ReplaceNullDateValueExample/Title