We have a field which has a minimum investment amount of $10,000. Can anyone provide me with guidance as to what is the most appropriate regular expression to use within the validation rule?
Ben's answer below covers how to do a simple min/max value validation, regular expressions are mainly used for pattern matching, eg email, phone number, social security number, tax file number, etc.
I would not use an regular expression for this. You can add a simple Validation Rule that will quickly achieve what you want.
For example the following validation rule:
produces the desired result:
Perfect - thank you Ben (and apologies for such a simple query)