topic Re: Age function in App Development

Age function

earlcool — Mon, 23 May 2022 20:12:58 GMT

I have a database with birth_date.

I use

Age(Today(), birth_date) as Age

I used later

=Count(Age >=18)

but it does not seem to work.

HugoRomeira_PT — Mon, 23 May 2022 20:41:25 GMT

Hello,

For the count, try the following function:

=count({<Age={">=18"}>} Age)

earlcool — Tue, 24 May 2022 13:19:58 GMT

thanks for the answer, however the personID makes a lot of visits to the store and they get counted on every visit.

I did create the database. I want to find the distinct or unique number without double counting.

thanks again.