Slice and dice with dates
Last edited: Jul 12, 2022 Published: Oct 19, 2011
Today we released a new data type on our platform to give you more power and flexibility with your data: Dates.
Now you can send Mixpanel a date and we’ll let you manipulate your data. You can find this in the segmentation report.
- Last time a user logged in
- The date that a user signed up
- The date of a specific action: photo upload, tweet, etc.
Integration is very intuitive. All you have to do is pass a property with a date formed as: “YYYY-MM-DD” (2011-01-01). You can also give us up to the second granularity if you’d like: “2011-01-02 03:34:21.” We will automatically interpret data that looks like this as a date.
Keep in mind, that you should send us dates that are in UTC format if they have granularity beyond a day level. If you send us data on a day granularity then we’ll simply take that and not convert it to UTC as it would be ambiguous.