It's been years since I've had to build a calculated field in FMP and the last time I did it was in FMP 7. I now have FMP 10, so checked the Help file to see if anything had changed. The Help file told me to use the If - Else If - Else If - Else - End If format, so I did. Trouble is, when I went to save the calculation, FMP told me there is no such function as Else If. What could be going on? Can the Else/Else If not be used on a text field, only number or something?

What I'm trying to do (Mac Snow Leopard) is take an expiry field with abbreviated months in it (ie Feb/Mar-10) and build a field which will print out February-March 2010 instead, because the printers are having trouble with the"/". If I can't figure this out I'll just change the / to a hyphen but it would be much more elegant to have it print properly.

Anybody have any ideas on why it won't let me use Else If? I even went back and kept the Help file open at the side to make sure I was doing it correctly and as far as I can see, I am.

--

Helen W. Lee, Kamloops, British Columbia
Webmaster, Canine Review Magazine: http://www.caninereview.ca
Savladai Borzoi (est'd 1969): http://goto-hwl.com/Savladai
Production & Design, Borzoi Connection


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/