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

3.11 - Student Birth Date 3.15 - Education Program Membership Start Date 3.16 - Education Program Membership End Date

Recommended correction path

Suggested resolution

Fields validated

  • 3.11 Student Birth Date
  • 3.15 Program Membership Start Date
  • 3.16 Program Membership End Date

Valid: 20260817   Invalid: 08/17/2026, 2026-08-17, 08172026.

Formatting and accuracy are separate. A perfectly formatted date may still belong to the wrong student, program, or event.

Recommended correction path

  1. 1

    Identify the failing date column

    Preserve the raw value and surrounding program key.

  2. 2

    Verify the actual event

    Birth Date comes from SINF-authoritative information; membership dates come from program records.

  3. 3

    Convert to CCYYMMDD

    Protect the eight-character value from spreadsheet locale conversion.

  4. 4

    Check chronology

    Start must not precede birth; End must not precede Start.

  5. 5

    Repair and audit

    Correct the export, resubmit, and review other date values.

Official FRMT0002 page