Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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)
Using Today ( function) you can calculate the years of patinets . Through nested if we can establish groups . Regards.
Do you have a sample you can share?
!Good evening, .qvw Attach a file. It can be seen as the deudaV2 , deudaV3 eyelashes ... I falsify dates . Regards.
Check the attachment please for clear example
Regards,
Check the last comment please.
Regards,
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)