This content has been marked as final.
Show 2 replies
-
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)1 of 1 people found this helpfulHey 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
-
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