Hi all,

We try to keep contact with our customers on their birthday. To create a list of the customers we should call during the month, I created a calculation using "=month status(currentdate)". The problem I am having is that it brings out 2 as a result instead of 10 (we obviously are in october). I checked the date on my pc running xp pro and on the linux server and both are linked to the atomic clock so that is not an issue. What could make this calculation bring this erronus result?

Thanks in advance for your suggestions.

-)

Luc

To show all the customers whose birthday is in the current month, you can try creating a script which would navigate through all the records, check for a condition if month(customerbirthdate)=month(status(currentdate)) then add the name to a global text field in a new line, else go to next record.

Luc:

If you just call Status(CurrentDate), what does it show?

-Stanley

2005-10-27

1. Is your calculation unstored?

2. Is your calculaton set to return result of type Number?

3. This may be a mere typo, but the syntax in your original message is incorrect. It should be:

Month ( Status(CurrentDate) )

Hi, in answer to your questions

1. Is your calculation unstored? = yes

2. Is your calculaton set to return result of type Number?= yes

3. This may be a mere typo, but the syntax in your original message is incorrect. It should be:

Month ( Status(CurrentDate) ) = indeed, I made a typo.

I am doing a test SI(MOIS ANNIVERSAIRE CLIENT = MOIS COURANT ;1 ;0) which translated comes to : if(customer's birthday month = current month;1;0) with mois courant = MOIS(ETAT( DateActuelle)) which translated is month ( status(current date)) and mois anniversaire client = MOIS(DATE FETE) which translated is custumer's birthday month = month ("birthday") with birthday being the customers birthday which is a date field.

So in retrospect, if ( Status(CurrentDate) brings out an october 28 date, I should be getting 10 as month, not 2. Any more ideas?

Thanks once more for your help.

:-)

Luc

Can you post your file?

233000 megabites...a bit big for the web, 3000 fields, 600 layouts, lots of scripts...so it would be a bit difficult(started out with the old filemaker 11 in 1988 on a mac 512!)

-)

Luc

Can you make a new file demonstrating your problem? You see, you are describing something that shouldn't be. We could keep guessing the cause till doomsday. It might even be a corruption in your file, or your application (if your new file doesn't have this problem, that would be an indication).

Uhm, I have just realized your FMP version must be lower than 7 (please update your profile). Which means I won't be able to look at your file (unless it's v.4) - but surely some other forum member will step in to assist.