Skip to main content

E032 Pay period end date is invalid

How to fix a pay period end date that Jarvis can't read, usually caused by incorrect date formatting.

Updated this week

What this means: Jarvis couldn't read the pay period end date; it's likely in an unexpected format.

Why this might happen: This often occurs when a CSV has been opened and resaved in Excel, which can reformat dates.

What to do

  1. Open the file in a text editor (not Excel) and check the date format:
    ​PAPDIS / NEST: should be YYYY-MM-DD (or DD/MM/YYYY)
    ​NOW:Pensions: should be DD/MM/YYYY

  2. If the dates look wrong, re-export from your payroll system without opening in Excel first

Watch out for Excel

Opening a CSV in Excel and then resaving it is a common cause of date formatting issues. If you need to inspect a CSV, use a plain text editor.

Did this answer your question?