[P1] Fix timezone issue with birthday on dashboard (#82) #96

New issue

Closed

opened 2026-07-07 16:21:56 +12:00 by fastie81 · 0 comments

fastie81 commented

2026-07-07 16:21:56 +12:00

Owner

Problem

Issue #82 "Time zone issue with birthday on dashboard" - birthdays show wrong day due to UTC vs local timezone.

Root Cause

date_of_birth stored as DATE (no timezone) in PostgreSQL
Frontend receives ISO date string (e.g., "1990-07-15")
JavaScript new Date("1990-07-15") parses as UTC midnight
Users in UTC+12 (NZ) see previous day (July 14)

Expected Behavior

Birthdays should display correctly in user's local timezone.

Fix Options

Backend: Return date with timezone context
Frontend: Parse as local date: new Date(dateString + 'T00:00000:00') or use dateString.split('-') to construct local Date
Store: Add timezone field to user profile

Recommended Fix (Frontend)

// In dashboard component
const parseBirthday = (dateString) => {
  const [year, month, day] = dateString.split('-').map(Number);
  return new Date(year, month - 1, day); // Local date, no timezone shift
};

app/core/entities/models.py (Member model date_of_birth field)
frontend/src/pages/dashboard/ (birthday display)
frontend/src/contexts/AuthContext.tsx (user profile with timezone?)

### Problem Issue #82 "Time zone issue with birthday on dashboard" - birthdays show wrong day due to UTC vs local timezone. ### Root Cause - `date_of_birth` stored as DATE (no timezone) in PostgreSQL - Frontend receives ISO date string (e.g., "1990-07-15") - JavaScript `new Date("1990-07-15")` parses as UTC midnight - Users in UTC+12 (NZ) see previous day (July 14) ### Expected Behavior Birthdays should display correctly in user's local timezone. ### Fix Options 1. **Backend**: Return date with timezone context 2. **Frontend**: Parse as local date: `new Date(dateString + 'T00:00000:00')` or use `dateString.split('-')` to construct local Date 3. **Store**: Add `timezone` field to user profile ### Recommended Fix (Frontend) ```typescript // In dashboard component const parseBirthday = (dateString) => { const [year, month, day] = dateString.split('-').map(Number); return new Date(year, month - 1, day); // Local date, no timezone shift }; ``` ### Related Files - `app/core/entities/models.py` (Member model date_of_birth field) - `frontend/src/pages/dashboard/` (birthday display) - `frontend/src/contexts/AuthContext.tsx` (user profile with timezone?)

fastie81 added the

labels

2026-07-07 16:21:56 +12:00

fastie81 closed this issue

2026-07-09 10:07:21 +12:00

fastie81 referenced this issue

2026-07-09 10:07:22 +12:00