Condition formula

[Landlord_Buddy]

I am creating a report but struggling with the formula.

There are two tables

1. Tenancy
2. Rent Due

I want to update the rent due table based on the Tenancy.

In the Tenancy table there is a column known as End_Date and I want to update the Rent due table on every 1st of each month so it shows me which property rent is due for that month ( I already have a view about this)

However the issue I am struggling to write the formula in condition field in report which would give me this result .

I appreciate your help

Thanks