Skip to main content

CALPADS error brief · FRMT

FRMT0002

Wrong date format
Severity Fatal
Error type Input Validation
Record type FRMT

Official CALPADS rule

What CALPADS is rejecting

Date format does not match CALPADS File Specifications (CFS)

Focus fields

Fields validated

2.04 Effective Start Date 2.18 Student Birth Date 2.05 Effective End Date 2.36 Student Initial US School Enrollment Date K-12

Recommended correction path

Suggested resolution

Fields validated

  • 2.04 Effective Start Date
  • 2.05 Effective End Date
  • 2.18 Student Birth Date
  • 2.36 Student Initial U.S. School Enrollment Date K–12

Severity: Fatal   Type: Input Validation

Valid and invalid examples

ValueResultWhy
20260827Valid formatCCYYMMDD, eight digits
08/27/2026InvalidSlashes and month-first order
2026-08-27InvalidHyphens make ten characters
20260230Invalid dateCorrect shape but nonexistent day

Format and accuracy are separate checks. A value can contain eight digits and still be the wrong birth, effective, or initial U.S.-school date. Verify the source record before reformatting.

Minimal correction path

  1. 1

    Identify the date field

    Inspect the raw SINF column.

  2. 2

    Verify the date

    Use authoritative demographic, enrollment, or cumulative records.

  3. 3

    Export CCYYMMDD

    Prevent spreadsheet auto-conversion and timestamps.

  4. 4

    Resubmit and verify

    Confirm FRMT0002 clears.

Official FRMT0002 page