Slice and dice with dates

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.

Examples

• Last time a user logged in
• The date that a user signed up
• The date of a specific action: photo upload, tweet, etc.

Integration

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.