Age calculation

[japanik]

Hello everybody. I am trying an age calculation. As result I only need years. However, the dates should compare only months. Means, the person should become already a year older on the first day of the month of the birthday, and the birthday should be compared with the creation date of the record, giving me the same result whenever the record is created (first day of the mont, or last day of the month).

Any good ideas out there?

[Raybaudi]

Hi

try this:

Year ( CreationDate ) - Year ( DoB ) - ( Month ( CreationDate ) < Month ( DoB ) )

[japanik]

That simple!!! Works, thanks a lot!!!