🐞DOB Validation Bug: System Accepts Future Dates in CSV Upload

[siddharthr29]

Description

While uploading individual data via CSV in the mlduat environment by client, the system is incorrectly accepting dates of birth (date_of_birth) that are in the future (i.e., greater than the current date). This results in invalid entries like 2086-06-26 being stored in the database.

Steps to Reproduce

1. Go to the CSV upload for individual records in the mlduat environment.
2. Upload a CSV file that contains a date_of_birth field with a date beyond today's date.
3. Run the following SQL query to verify:

   SELECT i.date_of_birth 
   FROM mlduat.individual i 
   WHERE i.date_of_birth > CURRENT_DATE;
   

Expected Behavior

System should reject or throw a validation error when date_of_birth is greater than the current date.

Actual Behavior

System accepts future date_of_birth values and stores them in the database without any validation errors.

Environment

• Environment: mlduat
• Affected Table: individual
• Upload Method: CSV Import

Screenshot

---

Please prioritize this issue as it affects data integrity and reports age filters.

[petmongrels]

probably already fixed. moving to hold.