31 Dec 2018: Thank you to our knowledgeable and friendly forums users for another great year. We are aware of the uptick in spam accounts and are doing our best to ban these at first sight. Thank you for your patience!

Partial Date Edit Check

Hi,

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.

Thanks,
Daniel

Comments

  • Malcolm HartMalcolm Hart Posts: 8
    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: 8
    By "< >" I mean of course gt, gte, lt and lte.
Sign In or Register to comment.