I Need a Formula Text Field titled Eligibility with 2 possible options (Eligible and Ineligible).

Tried plugging it is, it is saying the >= cant be applied on type duration.

IF(
[Are you a DC Resident?] = "Yes",
[# of days since last ERAP services] >= 365 or IsNull([This is a duration field]))
[Are you at least 30 days behind on Rent] = "Yes"
[Age] > = 18, "Eligible", "Ineligible")

try this

IF(
[Are you a DC Resident?] = "Yes",
[# of days since last ERAP services] >= Days(365) or IsNull([This is a duration field]))
[Are you at least 30 days behind on Rent] = "Yes"
[Age] > = 18, "Eligible", "Ineligible")

why does the "This is a duration field" need to be plugged into the formula?

It doesn't.  Just a copy and paste error.

Try this version


IF(
[Are you a Resident] = "Yes"
and
([# of days since last service] >= 365 or IsNull([# of days since last service]))
and
[Are you at least 30 days behind on Rent] = "Yes"
and
[Age] > = 18, "Eligible", "Ineligible")

Expected a valid expression after the ">"


IF(
[Are you a DC Resident?] = "Yes"
and
([# of days since last ERAP services] >= 365 or IsNull([# of days since last service]))
and
[Are you at least 30 days behind the rent?] = "Yes"
and

[Age] >   = 18, "Eligible", "Ineligible")

Do you gave a space between the > and the =  ?

it should be

>=

-after spacing it-

Expected a valid expression after the ">"


IF(
[Are you a DC Resident?] = "Yes"
and
([# of days since last ERAP services] >   = 365 or IsNull([# of days since last service]))
and
[Are you at least 30 days behind the rent?] = "Yes"
and
[Age] > = 18, "Eligible", "Ineligible")

Try this one


IF(
[Are you a Resident] = "Yes"
and
([# of days since last service] >= Days(365) or IsNull([# of days since last service]))
and
[Are you at least 30 days behind on Rent] = "Yes"
and
[Age] >= 18, "Eligible", "Ineligible")

looks like it works! Thank you!!

:) we got there, sorry it took so many iterations