How to Fix Invalid Date Formatting in OSHA ITA CSV Files
A date field is blank, impossible, or not formatted in the expected pattern.
What this means
OSHA 300/301 case data includes date fields such as date_of_incident, date_of_birth, date_of_hire, and date_of_death. Invalid or inconsistent dates can block a CSV upload.
Why this happens
- Dates were exported in a regional format such as DD/MM/YYYY.
- Spreadsheet software converted dates to serial numbers.
- Single-digit months or days were entered inconsistently.
- A death date or incident date conflicts with another case field.
How to fix it manually
- Review every required date field in the affected rows.
- Use the date format expected by OSHA's current CSV specifications.
- Fix impossible dates and dates that conflict with the incident outcome.
- Re-export and verify the CSV in plain text before upload.
How ITAReady helps
ITA Ready validates case-data dates and flags rows that need a formatting or logic review.
Related errors
Related guides
Fix the file before you upload again
ITA Ready checks common OSHA ITA formatting and validation issues, explains them in plain English, and helps you get to a corrected export faster.