Under 18 at any point during a time Frame?

[pdoucette]

I'm trying to figure out a way to see if a person we served was, at any point, under the age of 18 during a given time frame....7/1/19 - 6/30/20.  Age would be calculated off of a Birthdate field. 

[Regex · Accepted solution]

Please see full solution below.

Table1 contains two columns, with "Persons Name" and "Birthdate"

WasUnderage:=IF(COUNTROWS(Table1) <> 1, BLANK(), 

VAR DateOfBirth = VALUES(Table1[Birthdate])

VAR Date18 = DATE(YEAR(DateOfBirth)+18, MONTH(DateOfBirth), DAY(DateOfBirth))

VAR result = AND(DateOfBirth <= DATE(2020,30,6), Date18 > DATE(2019,7,1))

RETURN
result
)

[Regex · Accepted solution]

Please see full solution below.

Table1 contains two columns, with "Persons Name" and "Birthdate"

WasUnderage:=IF(COUNTROWS(Table1) <> 1, BLANK(), 

VAR DateOfBirth = VALUES(Table1[Birthdate])

VAR Date18 = DATE(YEAR(DateOfBirth)+18, MONTH(DateOfBirth), DAY(DateOfBirth))

VAR result = AND(DateOfBirth <= DATE(2020,30,6), Date18 > DATE(2019,7,1))

RETURN
result
)

[pdoucette]

Thank You, I think this is close but I am returning all False values but feel I met the Result...I will keep playing with it

[Regex · Accepted solution]

Hi,

There is a mistake in the order of one of the dates:

Try changing DATE(2020, 30, 6) to DATE(2020, 6, 30)

[jthomson]

Well you're only interested in the earliest part of the time frame - I don't know where that's coming from and it doesn't really matter, try something like:

18check = var earliesttimeframe = min(however you are defining your time frame)

var whenpersonis18 = dateadd([birthdate],18,year)

return if (earliesttime<whenpersonis18,"was under 18","wasn't under 18")