Checking Date Filters in Mixpanel for Custom Event Properties

Elena M. · 2025-09-25T14:15:29.906Z

how can I check if the time filter is below a certain date? how should I format this date threshold on Mixpanel UI for custom event properties?

Checking Date Filters in Mixpanel for Custom Event Properties | Mixpanel Community

2 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Hi Elena M., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
To filter events where a custom event property (e.g., a date property) is before a certain date in the Mixpanel UI, you should: 1. Format the date threshold as an ISO-formatted string: YYYY-MM-DDTHH:MM:SS in UTC. For example: 2023-12-31T00:00:00.2. Apply the filter in your report by selecting your custom date property and using the "is before" or "<" operator, then entering your threshold date in the ISO format above.Mixpanel expects date properties to be in ISO format and in UTC. When you use the UI to filter by date, ensure you enter the date in this format for accurate filtering. For example, to filter for events where "Account Created Date" is before January 1, 2024, you would use: LBKSAccount Created Date < 2024-01-01T00:00:00LBKSThis approach applies to both built-in and custom event properties of type "Date" in Mixpanel reports. If you are sending date properties to Mixpanel, always use the ISO format in UTC to ensure correct behavior in filters and reports <https://docs.mixpanel.com/docs/data-structure/property-reference/data-type#overview|Supported Properties Data Type> Manage Timezones for Projects.If you are using the API or JQL, you would use the same ISO format for date comparisons. The Mixpanel UI will interpret the date according to your project’s timezone setting, but the underlying value should always be in UTC ISO format.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.

kapa.ai
APP
·
·
Hi Elena M., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
To filter events where a custom event property (e.g., a date property) is before a certain date in the Mixpanel UI, you should: 1. Format the date threshold as an ISO-formatted string: YYYY-MM-DDTHH:MM:SS in UTC. For example: 2023-12-31T00:00:00.2. Apply the filter in your report by selecting your custom date property and using the "is before" or "<" operator, then entering your threshold date in the ISO format above.Mixpanel expects date properties to be in ISO format and in UTC. When you use the UI to filter by date, ensure you enter the date in this format for accurate filtering. For example, to filter for events where "Account Created Date" is before January 1, 2024, you would use: LBKSAccount Created Date < 2024-01-01T00:00:00LBKSThis approach applies to both built-in and custom event properties of type "Date" in Mixpanel reports. If you are sending date properties to Mixpanel, always use the ISO format in UTC to ensure correct behavior in filters and reports <https://docs.mixpanel.com/docs/data-structure/property-reference/data-type#overview|Supported Properties Data Type> Manage Timezones for Projects.If you are using the API or JQL, you would use the same ISO format for date comparisons. The Mixpanel UI will interpret the date according to your project’s timezone setting, but the underlying value should always be in UTC ISO format.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.