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
ss” help?
Thanks!
Page 1 / 1
Hi
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?
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.