Birthday Date Discrepancy in Profile vs. Listing View

Paras · 2025-06-23T11:40:09.007Z

Hey When viewing the birthday in listing it is showing different date but when viewing inside profile different date, sharing screenshot

Birthday Date Discrepancy in Profile vs. Listing View | Mixpanel Community

4 comments

· Sorted by Oldest

kapa.ai
APP
·
·
Sorry Paras, it looks like your question contains files, which I cannot process. Please reformulate your question without including any files.
Paras
·
·
When reading the DOB in listing in user listing then Date is different, but when trying to view in profile screen, date is showing different kapa.ai
kapa.ai
APP
·
·
Please stand by Paras as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
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.

kapa.ai
APP
·
·
Sorry Paras, it looks like your question contains files, which I cannot process. Please reformulate your question without including any files.
Paras
·
·
When reading the DOB in listing in user listing then Date is different, but when trying to view in profile screen, date is showing different kapa.ai
kapa.ai
APP
·
·
Please stand by Paras as I search the knowledge base. I normally take about 15 seconds or so. 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
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.