Today takes too long

[Jewel]

Hello!

I have a calculation field who takes the current year minus the birth year to display the player's category (soccer).

My current calc is like:

IF(Year(Today) - Year(Date de Naissance) < 19 ; "U" & (Year(Today) - ANNEE(Date de Naissance));"Senior")

The problem with this one is that everyday, the database calculates everything.

Which function should I use instead to avoid this? The only times I need to change the results are:

1- Once a year (January)

2- When adding new records

By the way, my Filemaker is french, so I tried to "translate" the functions I used...the french calc goes like:

SI(ANNEE(MAINTENANT) - ANNEE(Date de Naissance) < 19 ; "U" & (ANNEE(MAINTENANT) - ANNEE(Date de Naissance));"Senior")

Thanks !

Joel

[IdealData]

StatusCurrentDate can replace Today

Beware - if you want the result to be correct at all times then you must specify the calulation to be "not stored"

[Jewel]

Thanks !

I've finally been able to figure that one out