AnsweredAssumed Answered

Problems with "less than" calculation for numbers under 10

Question asked by KiraMcKenzie on Nov 21, 2010
Latest reply on Nov 22, 2010 by philmodjunk

Title

Problems with "less than" calculation for numbers under 10

Post

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.

Any ideas?

Kira

Outcomes