KB00010723: Date Regex Expression Validation Error

Issue:

The error “Date could not satisfy the validation pattern” (Figure 1) may occur when a date regex expression has been defined in Validation Rules (Figure 2) but is already functioning in Regex Builder (Figure 3). This issue applies only to 2019.2.

Figure 1: Validation Pattern Error

Figure 2: Date Regex Expression in Validation Rules

Figure 3: Regex Builder Screen

 

Solution:

To resolve this issue, implement the following script to set the field value to lower case.

if (currentFieldName.equals("Document Date")){

dlfValueDoc.setText(currentFieldValue.toLowerCase());

This will verify the date format of manual user entry without using the Date regex expression in Validation Rules.

Important: You will need to click Validate twice.