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
Yes, you can set a user profile property of type date in Mixpanel. According to the knowledge sources, Mixpanel supports five data types for properties, including Date.For date properties, Mixpanel expects an ISO formatted date in UTC timezone. The format should be YYYY-MM-DDTHH:MM:SS. Here are some key points about date properties in Mixpanel: 1. Date format: ISO formatted date YYYY-MM-DDTHH:MM:SS in UTC timezone.
2. Examples: Last Purchase = "2022-10-30T13:30:25", Last Login = "2022-10-29".
3. Timestamps are ingested with millisecond precision but exported with second precision.
4. You can break down your results by the "Time" event property and breakdown by Hour, Day, Week, Month, Quarter, Year, Hour of Day, or Day of Week.It's important to note that all timestamps need to be sent in UTC timezone in an ISO format for Mixpanel to recognize them as Date type.Mixpanel Docs: Supported Properties Data Type provides more detailed information on date properties and other supported data types in Mixpanel.
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.
