Validate Field is a valid date

How to build a Segment/Field rule validating that a field contains a valid date.  This one is sophisticated – take a look at the logic below.

We’ll validate that MSH.7 (Date/Time of message) contains a date. 

1. In the inbound HL7 task, select the Validation tab
2. Select the Segment/Field Validation tab
3. Add the rule: MSH.7 is matching regex ^20\d\d(0[1-9]|1[012])(0[1-9]|[12]\d|3[01])([01]\d|2[0-3])([0-5]\d)([0-5]\d)$

    

   

    

   This rule means that:

   • Year (^20\d\d): The first 2 characters must be 20 and the next 2 must be numbers
   • Month (0[1-9]|1[012]): Number between 01 and 12
   • Day (0[1-9]|[12]\d|3[01]): Number between 01 and 31
   • Hour ([01]\d|2[0-3]):  Number between 00 and 23
   • Minute ([0-5]\d): Number between 00 and 59
   • Second ([0-5]\d): Number between 00 and 59

We think this is a nice one…

 You can download the rule file for use in Caristix Workgroup or Test software.

Download the rules file (Field is a valid date.cxf)

Learn more about how to import validation rules into an inbound HL7 task.