Converting birthdates to numbers

[VWilson39]

About a month ago, I asked how to convert birthdate to numbers. And the advice I got was great. But lucky for me, it has bitten by in the a. I have to go by the original age at the time the youth registered for program. Is there a way to convert dates to a number with out updating birthdate. For example, A youth register on May 5, 2002 he was 18 and required a goal to be entered. When Query was run on May 6, 2002 he was 19 and a goal was not required. But since his register at the age of 18 he should have had a goal. Any suggestions would be greatly appreciated.

 

[mrabrams]

Sounds like one of those few instances where a calculation should be stored.
Create a field called AgeAtTimeOfRegister.
Store member's age at registration there.
Run your query based on that field.

Michael

 

[VWilson39]

Thanks, that make sense.