Previous page

Next page

Fixing date range order errors

Date range errors use the error code DATERANGE.

This topic shows an example of a date range error and how to correct it.

Example

Audit log information:

Checking table 'Employee'...

Executing rule 'Date range order'...

Found 1 violations for date pair (ALStartDate, ALEndDate):

Error code: [DATERANGE.] - EmployeeID: 1, ALStartDate: 5/10/2004 12:00:00 a.m. ALEndDate: 4/10/2003 12:00:00 a.m.

In this example, the employee with EmployeeID 1 has an annual leave table Start date after the End date.

To correct this problem:

  1. Navigate to Employees.
  2. Customise columns and display the Employee ID column.
  3. Open the employee with Employee ID = "1" and correct their annual leave table Start date and End date.

Topic: 22307