=AgeAt - fixed value in query

quarlton · Post by **quarlton** » 13 May 2016 11:46

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

Post by **tatewise** » 13 May 2016 13:20

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.

quarlton · Post by **quarlton** » 13 May 2016 16:15

Many thanks Mike, worked a treat.

Family Historian User Group

* =AgeAt - fixed value in query

=AgeAt - fixed value in query

Re: =AgeAt - fixed value in query

Re: =AgeAt - fixed value in query