Customer Portal

Problem with is_date

Comments 1

  • Avatar
    avackova
    0
    Comment actions Permalink
    I'm not sure, why the invalid date is passed through, but following code works properly:
    //#CTL1

    // Transforms input record into output record.
    function transform() {
    $0.field1 := str2date($field1,"dd/MM/yyyy");

    return ALL
    }

    // Called only if transform() throws an exception.
    function transformOnError(errorMessage, stackTrace) {
    $0.field1 := iif(is_date($0.field1,"yyyy-MM-dd"), str2date($field1,"yyyy-MM-dd"), null);
    return ALL
    }

Please sign in to leave a comment.