What is the right format for date in event properties

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!

Find more posts tagged with

Event Properties

Accepted answers

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

All comments

Saish Redkar

Hi Mykyta Ka

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?

Mykyta Ka

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 🤔

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

Mykyta Ka

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

Mykyta Ka

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!

Quick Links

Unanswered Questions

time format on import from Big Query
I am running into a loop when attempting to import data from BigQuery. At origin, my data is already in milliseconds since epoch. If I query: event_time as time, I get the error: 1.'time' column should be a TIMESTAMP_NTZ column (Snowflake) or a TIMESTAMP column (BigQuery). example for the type of 'time' column is…
Import data from one amplitude account to another
How do I transfer data from one amplitude account to another? It seems all the community chats about this have completely broken links. Easy to export, no way to import, very frustrating. :(
@amplitude/plugin-web-vitals-browser build fails on CRA v4 (react-scripts@4.0.3)
When using @amplitude/plugin-web-vitals-browser with Create React App v4 (react-scripts@4.0.3), the build fails with: ./node_modules/@amplitude/plugin-web-vitals-browser/node_modules/web-vitals/dist/web-vitals.js<br /><br />SyntaxError:…
Question about Amplitude Export API Data Delay
Hello, I'm using SpringBoot and Kotlin to integrate with the Amplitude Export API. The official Amplitude documentation (https://amplitude.com/docs/apis/analytics/export) states that "data is available to export at a minimum within 2 hours of when the servers received it." However, there's no clear information about the…
Retrieve via the API users based on a user property
Hello, Is there a way to make a query like: “Give me all the users that have the user property X equal to 10”, by using just any of the APIs, without making a cohort first through the Amplitude’s UI? Thank you!