Routine~10min

The Future Birthday

11 patient records have a date of birth set in the future. A migration script accidentally copied the registration date into the DOB field for a batch of new patients. These patients cannot be age-verified and are blocked from age-gated treatments.

Tables you'll query

patients

What you'll learn

Date & Time FunctionsSELECT & Filtering
Investigate this case →