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 Apr 26, 2016 12:45 PM

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!

1. Re: How to write a calc that finds and nulls out a certain date/time?

Derrick Austin Apr 26, 2016 1:27 PM (in response to Ariana Bray-Sweet)

Hey Ariana,

This timestamp is the "0" epoch timestamp (in PST). Somewhere along the lines, either in Tableau or in the DB, your data is getting typecasted and it is converting it to that datetime.

If you can't track it down to something you can control (in the DB for example), then you can do something like this, which will null it out again:
IF [myDate] <> #12/31/1969# THEN [myDate] END
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: How to write a calc that finds and nulls out a certain date/time?

Ariana Bray-Sweet Apr 28, 2016 3:25 PM (in response to Derrick Austin)

Thanks for your response, Derrick! I took your advice and tweaked it slightly. Thanks for helping me get on the right path! Here's how it ended up:

IF [myDate] < #1/1/1970# THEN NULL
Else [myDate]
END
Like Show 1 Likes(1)

Actions

Go to original post

Tableau Community Forums

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

1. Re: How to write a calc that finds and nulls out a certain date/time?

2. Re: How to write a calc that finds and nulls out a certain date/time?

Actions

More Like This