Generate Date to age groups

[Anonymous]

I have [dateOfBirth] for patinets and i want to make group for them per ages

for example:

Age Group

00-15

16-31

32-47

47+

Regards,

[#2]

Using Today ( function) you can calculate the years of patinets . Through nested if we can establish groups . Regards.

[sunny_talwar]

Do you have a sample you can share?

[#4]

!Good evening, .qvw Attach a file. It can be seen as the deudaV2 , deudaV3 eyelashes ... I falsify dates . Regards.

[Anonymous]

Check the attachment please for clear example

Regards,

[Anonymous]

Check the last comment please.

Regards,

[sunny_talwar · Accepted solution]

May be this expression in list box:

=Aggr(If(Age(today(), Only({1}dateOfBirth)) < 16, Dual('0-15', 1),

   If(Age(today(), Only({1}dateOfBirth)) < 32, Dual('16-31', 2),

   If(Age(today(), Only({1}dateOfBirth)) < 48, Dual('32-47', 3), Dual('47+', 4)))), dateOfBirth)