I am new to commcare and i am trying to filter filter a case list. Basically, i have Date of Visit and Age variables and i would like to add a calculated property called Current Age. Then finally filter cases using Current Age.
To calculate the Current Date , i am trying this:
int((today() - date(date_of_visit)) div 365.25) + age
Then i would like to filter case list as below:
Current Age < 5 #To list all members who are less than 5 years
Looking for any contribution