Check for invalid dates in investigation records

1. In the main FH toolbar, click Investign.

   The Investigation dialog box appears.

2. At the bottom of the dialog box, click Browse.

   The Query dialog box appears.

3. From Select a Query, choose UPSIZE Investigation Query.

   The list in the Query dialog box updates, displaying all the patient dates in the Investigation module.

   

4. Check each column for invalid dates.

   1. 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.

         

   2. 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.
   3. Repeat steps a–b for every date column in the query.

5. For every record containing an invalid date (date outside the range), correct the date.

   Column name	Correct an invalid date
   Invest Status Date Invest Start Date	Continue with Correct the start and status dates.
   Evidence Description Evidence Date Agency with Custody Custody Out Custody In Test Code Test Date Test Start Date	Continue with Correct evidence dates.
   Involved Last Name Involved First Name Involved DOB Involved Arrest Date Involved Conviction	Continue with Correct lead/involvement dates.
   Picture Description Picture Taken Date	Continue with Correct photos dates.
   Referring Agency Referral Date	Continue with Correct the referral date.

6. Check the dates in other modules you have purchased, as described in Check for invalid dates in modules.