-
1. Re: How to write a calc that finds and nulls out a certain date/time?
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?
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