Birthday Date Discrepancy in Profile vs. Listing View
Hey kapa.ai When viewing the birthday in listing it is showing different date but when viewing inside profile different date, sharing screenshot
Hey kapa.ai When viewing the birthday in listing it is showing different date but when viewing inside profile different date, sharing screenshot
The difference in the Date of Birth (DOB) shown in the user listing versus the profile screen is likely due to timezone handling in Mixpanel. Here’s what the knowledge sources indicate: - Mixpanel stores all event and profile data timestamps in Coordinated Universal Time (UTC). However, the way dates are displayed in the UI depends on your project’s timezone settings. If your project’s timezone is set differently, the same timestamp can appear as a different date in different parts of the UI, especially if one view is using UTC and another is using your project’s local timezone for display output. This can cause a date like a DOB to appear off by a day depending on the timezone offset applied in each context Manage Timezones for Projects.- When exporting or importing data, or when setting date properties, Mixpanel recommends always using UTC and ISO-formatted date strings to avoid such discrepancies. If the DOB was set with a local timezone or in a non-UTC format, it may be interpreted differently in various parts of the UI.- The knowledge sources do not specify exactly how the user listing and profile screen each handle date display, but the described behavior matches known timezone-related issues.To resolve this, ensure that all date properties (like DOB) are stored and sent in UTC and ISO format, and check your project’s timezone settings to ensure consistency across all views Manage Timezones for Projects.If you continue to see discrepancies, it may be helpful to review how the DOB is being set and displayed in your implementation, and confirm that all systems interacting with Mixpanel are using consistent date formats and timezones.
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.