Skip to main content
Solved

Segment on invalid date

  • February 26, 2025
  • 4 replies
  • 19 views

I would like to segment on invalid date at created at but I can’t? What should I write?

 

Best answer by Felix

Hey Stina,

I think Michael has a good point!

You can also try to segment on “created_at” ist not a timestamp. That should give you all the invalid ones, because all the others are a valid timestamp.

 

Hope that helps,

Felix

View original
Did this topic help you find an answer to your question?

4 replies

boostmyemail

My guess is the value isn’t “invalid date” but something else, probably some kind of syntax error or character missing. Can you look at the records with invalid dates and find a pattern in the actual value there?


Felix
  • Novice
  • 223 replies
  • Answer
  • February 26, 2025

Hey Stina,

I think Michael has a good point!

You can also try to segment on “created_at” ist not a timestamp. That should give you all the invalid ones, because all the others are a valid timestamp.

 

Hope that helps,

Felix


boostmyemail
Felix wrote:

Hey Stina,

I think Michael has a good point!

You can also try to segment on “created_at” ist not a timestamp. That should give you all the invalid ones, because all the others are a valid timestamp.

 

Hope that helps,

Felix

Felix’s answer was much simpler than mine haha. 


Felix
  • Novice
  • 223 replies
  • February 26, 2025

😂 Had to check myself if “is not a timestamp” exists actually...


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings