I have added a new field to my FM solution (FM14) and have been told that it can only be in the format NN.NN ie two numbers, a decimal point/period followed by two numbers. I tried to write a calculation to validate it but couldn't get it right, then wondered if I'm complicating things too much? The field is currently set to be numeric with a maximum of 5 characters, which is fine but I want to ensure that users enter it exactly as required. I've searched and found lots of examples for an input mask for a phone number, but can't find anything to get me started with this question.
Any help/advice/suggestions gratefully received