Calculation Formula

[Chrissy]

Hello

I am very new to FileMaker Pro and am using FMP 8 to create a database of client information. This database includes all information relating to their reporting dates and next reporting dates. I want to add a field that will indicate a number of hours of community service completed each month. I have created it as a calculation field but I want it to automatically revert to 0 (zero) on the first of each month. I am not sure what the formula should be to do this. Is anyone able to provide me with the formula that I should be using? Another formula I want to create is to change the colour of text from black to red and the font from regular to bold when the client's expiry date is 30 days away. This field has also been created as a calculation field and again I am having difficulty working out what the formula should be.

Any help you can give me would be fantastic.

Thank you so much!

Chrissy

[Peter (duksis3)]

You need to check Month on startup (I suppose that file is opened and clodsed every day) via

If Month(Get Current Date) > Month (Get Current Date-1).

Next depend on what type you wnt to set to 0 - auto enter serioal or what. If Auto Enter serial the use Set next serial value 0.

To change color in FMP 8 cannot be used conditional formating as in FMP 9 or 10.

So you need to make 2 calculation fields, transparent on Layout, and position them Align Centers (one on top another). And set text color Red for 1st and Black for 2nd.

Set field CurrentDate = Get (CurrentDate) on FileOpen script.

First calculation (red) If(Current date-Date due)>30; Your Value;"")

Second calculation (black) If(CurrentDate-Date due(<30; Your Value;"")

Or something similar :(

[comment]

I suggest you take a look at a similar issue here:

http://www.fmforums.com/forum/showtopic.php?tid/212237/

[Chrissy]

Thanks. I will be back at the office on Monday and will be working on the database again. I hope to have it ready to go by Dec 1.