Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I got help before on different parts of this but I think this one query is still not quite right.
I need all kids ages 18-21 years old (so 216 months to 252 months). I think I need some sort of ages between and this is giving me all ages greater than 18 and all ages less than 21 but going beyond. The math on the raw data shows a lot less, the formula is showing a large number. Any help is appreciated
Count(distinct {<[Enrollee Date of Birth.autoCalendar.Date]={">=$(=Date(AddMonths(Today(),-216)))<=$(=Date(AddMonths(Today(),-252)))"}>} medicaidID)
Pl share what do you see at the bottom of expression editor, would like to see how this expression is looking like after $ expansion. Mostly date formatting mismatch between left side and right side could cause trouble.
Pl share what do you see at the bottom of expression editor, would like to see how this expression is looking like after $ expansion. Mostly date formatting mismatch between left side and right side could cause trouble.
The Expression editor says ok. Aah, I did not realize it showed something different here:
Count(distinct[<[Enrollee Date of Birth.autoCalendar.Date]={">8/16/2004<=8/16/2001"}>}[RecipientNumber-medicaidID])
I switched the greater and less than signs and now it works. Thanks!!!