Age Calculation

[Tmonk]

Hello. I am new to filemaker and have very little experience so please bare with me. I have learned a little just from reading through the threads. I need to create a calculated field that will give me "age" based on two other criteria besides birth date. If one's gender is "M" I need to calculate their age as of August 1 of the current year. If one's gender is "F" i need to calculate as of January 1 of the current year. Can anyone lead me in the right direction? Thanks.

[-Queue-]

Well, I'm opting not to get naked (baring) , but I believe this calc will work for you.

Case( gender = "M", Int( ( Date( 8, 1, Year( Status(CurrentDate) ) ) - birthdate ) / 365 ), gender = "F", Int( ( Date( 1, 1, Year( Status(CurrentDate) ) ) - birthdate ) / 365 ) )

[Tmonk]

Thanks! That was revealing !

[-Queue-]

Tsk tsk, Thelonious.