Page 1 of 1

=AgeAt - fixed value in query

Posted: 13 May 2016 11:46
by quarlton
Hi

Is it possible to use AgeAt in a query with a fixed value rather than having it prompt.

e.g. =AgeAt(%INDI%, 1960)

I know it's not a major issue, but it would be nice.


Thanks

Re: =AgeAt - fixed value in query

Posted: 13 May 2016 13:20
by tatewise
Yes, use the =DateAt() function to specify the Date.
e.g.
=AgeAt(%INDI%,DateAt(1960,0,0))

i.e. Year=1960, Month=0 means none, Day=0 mean none
or Year=1960, Month=5 means May, Day=13 means 13th.

Re: =AgeAt - fixed value in query

Posted: 13 May 2016 16:15
by quarlton
Many thanks Mike, worked a treat.