Age Calc

[agaperrk]

I have an age calc

Let ([

today = Get(CurrentDate);

datedif = today - birthday+1];

Year ( datedif ) -1

)

I put it in as an custom function. This has worked fine, until I enlarged the network and put filemaker server 7 on and every now an then it will not calc the field. I have indexing turned off and at a loss for what the problem might be. Is there something on the server that need to be selected so that it calculates that field everyday.

Thanks in advance.

Randy :)

[comment]

1. The calculation field must be unstored.

2. This is not a good way to calculate age - see here why:

http://fmforums.com/forum/showpost.php?post/150140/

[Lee Smith]

Hi agaperrk,

[color:red]comment has linked several threads regarding "Age" calculations in his Blog, you should take a few minutes to read them here.

HTH

Lee

Edited January 19, 2010 by Guest

[agaperrk]

I am still having trouble with the age calc. The file is running on a server.. with clients and It calcs right but it is not calculating when the clients open. So the age will change if you make a change in the field and then put back. but if it has been a year since messing with the file it does not calc until you play with the date field.

It is like you have to manually change the date.

Let([n = Get(CurrentDate); b = Birthday];

Year(n) - Year(: - ((Month(n) + Day(n) / 100) < (Month( + Day( / 100))

)