Yes, Mixpanel supports the use of formulas and functions in custom properties to work with date and time data. However, there isn't a specific function to cast a result as a date or time. Instead, you can use the datedif function to subtract two dates. The syntax for this function is datedif(start_date,end_date,unit). For example, datedif(registrationdate,TODAY(), "M") would calculate the number of months since a user's registration date.
If you have a property that is a unix timestamp and got sent as a number, you can typecast it to a Date data type in Mixpanel reports. An ISO formatted date YYYY-MM-DDTHH:MM:SS in UTC is used for the Date data type. Note that all timestamps need to be sent in UTC timezone in an ISO format.
For more details, you can refer to the Mixpanel documentation on custom properties and data types.
