Problems with "less than" calculation for numbers under 10
Hi there - I hope you guys can help me out with this. I am using FileMaker Pro 7.
What I need to do is be able to enter a birthdate, and have an age calculated - I have a calculation for this and it works. Next, I need to create a script that based on that age, prints either a single layout (if the age is 18 or over) or two layouts (if the age is under 18). I have it working perfectly, EXCEPT for that it doesn't work for ages under 10.
I am guessing that the problem has to do with the age under 10 being a single digit, but I'm not sure how to get around that. I don't see a way to force the age calculation to come out as 09 or 06 or whatever.
Hopefully this is clear.