Check for invalid dates in modules

Windows SQL Server requires that dates in SQL databases are greater than 01/01/1753 and less than 12/31/9999. FH does not have a similar restriction; as a result, it is possible to have entered dates in your FH database outside the 01/01/1753 to 12/31/9999 date range, or to have imported data from files containing dates outside the range.

Caution: If you have dates outside this range in your FH database, records with these dates will upsize to SQL Server, but the date fields will be blank after the upsize.

To prevent this, you should check the all dates in your FH database, verify that they fall within the required date range, and correct any dates that fall outside the range.

• Follow the directions below that correspond to the records you keep in your FH database.

  Example: You have purchased the Incidents, EMS, and Inventory modules in FH. You only need to check the dates in those records, and can skip the instructions for checking dates in any other records.

  Records type	Do this
  NFIRS incidents	Check for invalid dates in NFIRS incident records.
  EMS incidents	Check for invalid dates in EMS incident records.
  Investigations	Check for invalid dates in investigation records.
  Occupancies	Check for invalid dates in occupancy records.
  Inspections	Check for invalid dates in inspection records.
  Staff members	Check for invalid dates in staff member records.
  Staff activities	Check for invalid dates in staff activity records.
  Training classes	Check for invalid dates in training classes records.
  Training programs	Check for invalid dates in training program records.
  Inventory	Check for invalid dates in inventory records.
  Hydrants	Check for invalid dates in hydrant records.
  Accounts	Check for invalid dates in account records.
  Account statements	Check for invalid dates in account statement records.
  Scheduling	Check for invalid dates in staff scheduling records.
  Events	Check for invalid dates in department event records.
  Remote responses	Check for invalid dates in dispatch and remote station response entry records.
  Daily reminders	Check for invalid dates in daily reminder records.
  Vendors	Check for invalid dates in vendor records.