We want to do operations for event properties of date type. For example filtering by events with date-type event property that are more than a year ago (we use such properties for date-based filters for example).
So far were were sending data in format of “YYYY-MM-DD” and Amplitude sees it as a string and doesn’t allow comparison operations.
What format should I use, will changing to “YYYY-MM-DDTHH:mm:ss” help?
Thanks!
Solved
What is the right format for date in event properties
Best answer by Saish Redkar
AFAIK, the behavior should be the same for both user and event properties ingested in date format.
The “greater than” operator should be available irrespective of the property type
+10Hi
We ingest one of our user properties in the "date": "2024-12-01" format and I’m able to compare without any issues. Can you verify from your raw event data how the format is shown?
Thank you, note that I meant event properties here, in raw data it looks this way:
"expiry_date": "2024-12-18"
And when I for example go to segmentation report and try to filter by properties I don’t see comparison like “greater than”, but I have hunch that actually it’s impossible to filter by property there at all.
And maybe one should actually go to data table for that 🤔
+10AFAIK, the behavior should be the same for both user and event properties ingested in date format.
The “greater than” operator should be available irrespective of the property type
Got it, so when I try to use segmentation report, I see only ability to multi-select when trying to filter by event property (see below)
Interesting where you are able to find such filter for event properties, my guess that it’s other types of reports, and maybe segmentation just has limited filtering capabilities by design
My bad, I actually missed the comparison operator to the left of the value. Thank you for leading me in the right direction, feeling somewhat awkward for missing that!
1 person likes this
Reply
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. You can also create a Guest account below!
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Welcome to the Amplitude Community!
If you don't have an Amplitude account, you can create an Amplitude Starter account for free and enjoy direct access to the Community via SSO. Create an Amplitude account. Want to sign up as a guest? Create a Community account.
If you're a current customer, select the domain you use to sign in with Amplitude.
analytics.amplitude.com analytics.eu.amplitude.comor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.