AnsweredAssumed Answered

Hour Validation Script

Question asked by hrcap on Aug 24, 2013
Latest reply on Sep 4, 2013 by hrcap

Title

Hour Validation Script

Post

     Afternoon All

      

     I have created a script for work on object exit, this script should ensure that the hour entry is in the correct format, the script currently works to ensure that the entry is either 0 characters long or 2 characters long.

      

     The calculation is contained under an IF statement, so when it is true it displays a custom dialog saying "hour entry invalid"

      

     The final step of the calculation is not working and i would appreciate some input, the final step ensures that the number entered is less than or equal to 24

      

     the calculation is below

      

      

     Many Thanks

      

     Hadleigh

      

     Let(

      

      
     @Numbers = TextFormatRemove (Filter (GetField (Get (ActiveFieldTableName) & "::" & Get (ActiveFieldName) ) ; "0123456789")); 
      
      
     Length(@Numbers)  ≠  2
      
     and
      
     Length(@Numbers)  ≠  0
      
     and
      
     @Numbers  > 24
      
     )

Outcomes