Getting the above error in the formula below And ([Rent Due Date] >= Day (Today()), Tenant[Tenancy_End] >= Day (Today()))

I am creating a report but struggling with the formula. There are two tables Tenancy 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 o...

Hello I want to automatically update the table. I am creating a app for landlord. There is a table which has a start date and end date for the tenancy. The rent is due every monthly or weekly. I want to update the rent due table every month so that a...

I want some rows created automatically in a table. There is a table A which has Start Date and End Date. In table I want to create some rows automatically on the first of every month. This is then showed in the view

I have a table 1 which has a start date and end date I want to update a column x in table 2 if todays date falls between start date and end date of table 1