I would like to segment on invalid date at created at but I can’t? What should I write?
Solved
Segment on invalid date
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
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?
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
More questions? Shoot me a message by clicking on my name. We are a certified customer.io agency. Happy to help!
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.
Michael Roberts | boostmyemail.com
1 person likes this
😂 Had to check myself if “is not a timestamp” exists actually...
Reply
Most helpful members this week
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.