Changing Mixpanel Event Property Type from Datetime to Date Only

I’ve added a new event property about a selected date I’m sending value with format such as YYYY-MM-DD but mixpanel displays format such as YYYY-MM-DDTHH:MM:SS using the same random time 02:00:00 for all events How can I change the property.type from Datetime to Date only ?

2 comments

kapa.ai
APP
·
·
Hi Tanguy D., 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
·
·
Mixpanel supports the Date property type, which expects an ISO-formatted string in the format YYYY-MM-DDTHH:MM:SS (in UTC). If you send a value like YYYY-MM-DD, Mixpanel will automatically append a default time (often 02:00:00 or 00:00:00) to make it a full datetime, since the Date type in Mixpanel is essentially a datetime with time precision, not just a date. This is expected behavior and is not configurable to display only the date part in the UI or change the property type to "Date only"—Mixpanel always treats Date properties as full datetimes in ISO format and displays them as such Supported Properties Data Type.There is currently no way to force Mixpanel to treat a property as "date only" (YYYY-MM-DD) and display it without the time component. If you want to avoid the time being shown, you could consider sending the property as a String instead of a Date, but then you lose the ability to use date-specific operators and breakdowns in Mixpanel reports Property Data Types.Summary: - Mixpanel's Date type always expects and displays a full datetime (YYYY-MM-DDTHH:MM:SS). - Sending only YYYY-MM-DD will result in Mixpanel appending a default time. - There is no supported way to change the property type to "Date only" or hide the time in the UI. - If you need to display only the date, consider using a String property, but this limits date-based analysis.For more details, see the documentation on Supported Properties Data Type and Property Data Types.
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.