2 Replies Latest reply on Apr 28, 2016 3:25 PM by Ariana Bray-Sweet

    How to write a calc that finds and nulls out a certain date/time?

    Ariana Bray-Sweet

      Hello community!

      I have a dataset that includes the date/time when an email subscriber confirmed their subscription. The problem is that for people who have not confirmed, that null date was for some reason brought in as 12/31/1969 4:00:00 PM. How would I write this calculation so that Tableau will turn all the records with that date into a "null" or empty?

       

      Relevant Notes: The date field in question is currently a "Date/Time" field. I cannot post the packaged workbook because of the personal data within.

       

      Thank you!