2 Replies Latest reply on Nov 22, 2010 10:13 AM by philmodjunk

    Problems with "less than" calculation for numbers under 10

    KiraMcKenzie

      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