Jump to content

www

Newbies
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About www

  • Rank
    newbie
  1. Thanks everybody...I realized my error was being reported in the middle of the calc...I had pasted the calculation from notepad into fm and somehow a line break got stuck in the middle!
  2. I have this calc that gives the age of someone as of today: NumToText(Year(Today) - Year(Student Date of Birth) - If(Today< Date(Month(Student Date of Birth), Day(Student Date of Birth), Year(Today)), 1, 0)) & " Years, " & NumToText(Mod(Month(Today) - Month(Student Date of Birth) + 12 - If(Day(Today) < Day(Student Date of Birth), 1, 0), 12)) & " Months, " & NumToText(Day(Today) - Day(Student Date of Birth) + If(Day(Today) >= Day(Student Date of Birth), 0, If(Day(Today-Day(Today)) < Day(Student Date of Birth), Day(Student Date of Birth), Day(Today- Day(Today))))) & " Days" I changed it to give the person's age as of 8/15/2003: NumToText(Year(Date( 8, 15, 2003 )) - Year(Student Date of Birth) - If(Date( 8, 15, 2003 )< Date(Month(Student Date of Birth), Day(Student Date of Birth), Year(Date( 8, 15, 2003 ))), 1, 0)) & " Years, " & NumToText(Mod(Month(Date( 8, 15, 2003 )) - Month(Student Date of Birth) + 12 - If(Day(Date( 8, 15, 2003 )) < Day(Student Date of Birth), 1, 0), 12)) & " Months, " & NumToText(Day(Date( 8, 15, 2003 )) - Day(Student Date of Birth) + If(Day(Date( 8, 15, 2003 )) >= Day(Student Date of Birth), 0, If(Day(Date( 8, 15, 2003 )-Day(Date( 8, 15, 2003 ))) < Day(Student Date of Birth), Day(Student Date of Birth), Day(Date( 8, 15, 2003 )- Day(Date( 8, 15, 2003 )))))) & " Days" Now, I'm getting the error: Too many separators. Am I correct in replacing the "Today" keyword with Date(8,15,2003) to get the result I'm looking for? Why too many separators? Any hints appreciated! I'm a beginner! Thanks!
×

Important Information

By using this site, you agree to our Terms of Use.