Checking Date Filters in Mixpanel for Custom Event Properties

Elena M. · 2025-09-25 14:15:33.646077+00

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?

See us at ProductCon in SF on Oct. 8th! Check out #03_resources-and-events channel for more info.

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

2 comments

· Sorted by newest

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

Loading comments

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