### Title

Auto Enter Calculation

### Post

Hi Guys

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.

There are at least two different problems in that part of your calculation. The correct syntax for what you intended is:

@Numbers ≠ 1 or @Numbers ≠ 2 or @Numbers ≠ 3

But this won't totally fix things here as the valid value of 12 will be flagged as an error becase 12 ≠ 1 is a true statement.

I suggest that you use

Right ( "0" & @Numbers ; 2 )

) // case

) // let