Check for invalid dates in staff member records
-
In the main FH toolbar, click Staff.
The Staff dialog box appears.
-
At the bottom of the dialog box, click Browse.
The Query dialog box appears.
-
From Select a Query, choose UPSIZE Staff Query.
The list in the Query dialog box updates accordingly.
-
Check each column for invalid dates.
-
Double-click the column title.
A column sort icon appears on the right side of the column, indicating whether the column is sorted from highest-to-lowest or lowest-to-highest.
- Check the dates near the top and bottom of the column to see if there are dates outside the range 01/01/1753 to 12/31/9999.
- Repeat steps a–b for every date column in the query.
-
-
For every record containing an invalid date (date outside the range), correct the date.
Column name Correct an invalid date Hire Date
Adjusted Hire Date
End Service Date
DOB
Rank Date
Status Date
-
Continue with Correct basic staff member dates.
Admin Expires
Admin EMS Certificat
Admin Current Certif
Admin Original Certi
Admin EMS Employment
Admin Agency Certifi
Admin Length of Serv
Availability From
Availability To
History Date
Pay From Date
Pay To Date
- Continue with Correct additional records dates.
-
- Check the dates in other modules you have purchased, as described in Check for invalid dates in modules.