Mixpanel Community Icon

How do I change the Datetime Type format of a property

·
·

How do I change the Datetime Type format of a property

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    Hi Mattias N., 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

  • Avatar of kapa.ai
    kapa.ai
    APP
    ·
    ·

    To change the Datetime Type format of a property in Mixpanel, you can use typecasting. Mixpanel allows you to force properties into another data type using the "Data Type" option. Here's how you can do it:1. In your Mixpanel report, locate the property you want to change. 2. Find the overflow menu for property filters and breakdowns. 3. Select the "Data Type" option from this menu. 4. Choose the desired data type for your property.For datetime properties specifically, Mixpanel recommends using an ISO-formatted date string (YYYY-MM-DDTHH:mm:ss) in UTC timezone Changing your Timezone.If your property is currently in a different format or data type, you can typecast it to the Date type. This is particularly useful if, for example, your property was sent as a numeric Unix timestamp and you want it to be treated as a Date property instead Typecasting.Remember that while typecasting allows you to change the data type for analysis purposes, it's always best practice to keep a property's data type consistent during implementation to avoid confusion 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.