Skip to main content

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! 

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?

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 🤔

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
 

 

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! 

 

 

Reply


Terms & ConditionsCookie settings