1 Reply Latest reply on Jun 5, 2015 8:42 AM by raybaudi

    Validate Length

    DavidGibson_1

      Title

      Validate Length

      Post

      I've got two types of data in one field.  The character length for data type A is 10 digits, the character length for data type B is 14 digits.  I'm trying to restrict data entry to either 10 digits or 14 digits.  I've tried the following validation formulae.

      IsEmpty ( Self ) or  ( 9 < Length ( Self ) and Length ( Self ) < 15 )

      and,

      Case ( IsEmpty ( Self );Length ( 10 );Length ( 14 ) )

      Neither of these work. Am I on the right track or totally wrong?