Inside Mixpanel

Slice and dice with dates

Suhail Doshi

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

Get the latest from Mixpanel
This field is required.