what date format does mixpanel accept
what date format does mixpanel accept
what date format does mixpanel accept
Hi Zeyad Y., 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
Mixpanel accepts date properties in ISO format (YYYY-MM-DDTHH:MM:SS) in UTC timezone. Here are the key points about date formats in Mixpanel:
1. Date Format: ISO formatted date YYYY-MM-DDTHH:MM:SS in UTC.
2. Timezone: All timestamps need to be sent in UTC timezone.
3. Precision: Timestamps are ingested with millisecond precision, but exported with second precision.
4. Unix Timestamps: Mixpanel treats unix timestamps as Numeric properties, but you can typecast them to Date data type.
It's important to note that when sending date properties to Mixpanel, you should ensure they are in UTC. Here's an example of how to format dates correctly in JavaScript:
```
mixpanel.track("Sign Up", {"Account Created Date": new Date().toISOString()});
LBKSThis format allows you to use date-related features in Mixpanel reports, such as breaking down results by Hour, Day, Week, Month, Quarter, Year, Hour of Day, or Day of Week.
[Mixpanel Documentation - Supported Properties Data Type](https://docs.mixpanel.com/docs/data-structure/property-reference/data-type) provides more detailed information on date formats and other supported 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.