Auto Enter Calculation
I need some help if possible.
I have a field called dob_day, this field is used to enter the day of the month that someone was born and so must contain a value 01 - 31.
I have most of my auto enter calculation sorted that ensures that the number is entered in the correct format, e.g if "1" is entered it will turn the number into "01" or if "111" is entered it will turn the number red to show an error.
I wish to modify this auto enter calculation slightly so that it will only allow the entry of the numbers 01 - 31 and if a different number is entered it will turn red.
Below is the calculation that i have so far, i think the part that needs modifying is the if statement with the *** next to it, in particular the part: @Numbers ≠ ("1" or "2" or "3") NB: this should go all the way to 31 once the caluclation is correct.