I have a database that contains one record per national holidays. As you know, not all holidays have fixed dates (ie Vicroia Day (i'm in Canada) is the monday previous to the 24th of May). I could create a calculation field that will calculate the date of the next occurence but I would have to create one field per holiday OR create one huge calculation field with a Case that handles every holiday. My db will contain every national holiday for every country, so I mean HUGE calculation field. In any case I would have to define or modify my filed formulas everytime I add a holiday which would be annoying since I will be sharing the db with fmp server.

I thought maybe I could store the calculation formula in a text field and have another calculation field return the date. Is there a way to tell fmp to use the content of a text field as a calcualtion formula ?

Thanks.

I would probably create a script to generate the holiday records. That way you can add script steps as necessary to calculate and generate a holiday record for each holiday that you need. I don't like long calculation formulas either; they tend to be hard to debug.