We hope you'll join us for our 4/23 webinar on using data tables to apply reference ranges and AE codes in OC4. For more information and to register, visit https://register.gotowebinar.com/register/2882170018956684555

Partial Date Edit Check


Is there a way to check partial dates to ensure that end date is not prior to start date? Both fields are on the same CRF.



  • Malcolm HartMalcolm Hart Posts: 21
    Hi Daniel

    You cannot use the < > operators in XML rules to compare a partial date with another date. Although OC will happily let you import the rule without a murmur, and it won't say anything when the rule is summoned during data entry, if you try to test the rule you'll get the following:

    Rule Validation: Valid

    Expression Evaluates To: FAIL OCRERR_0001 : Logic Error, I_ID004_CONDITION_ENDPDATE and _CURRENT_DATE cannot be used with the GREATER_THAN operator.

    Actions Fired: N

    Ran in: 0.001 seconds

    Action Summary: No actions will be executed

    Not sure how a rule can be considered "valid" if it features an illegal syntax, but there you go. I haven't found any documentation that mentions this hidden pitfall either. All a bit underwhelming really.
  • Malcolm HartMalcolm Hart Posts: 21
    By "< >" I mean of course gt, gte, lt and lte.
Sign In or Register to comment.