Jan 12 2022 09:29 AM - edited Jan 12 2022 09:50 AM
I need to calculate if a person is 20 months old today or will be 20 months old this year based on a dob. I've tried with some datedif but I can't figure out how I would calculate this.
If I do a datedif and grab kids 20 months to 31 months, I'm getting kids who were greater than 20 months in January. So if a kid turns 20 months in January I want them on the file. If they were 22 months in January, I don't want them. If they turn 20 months in February, I want them on the file. So I only want them on the file if they turn 20 months in this calendar year.
Jan 12 2022 11:41 AM