Update another table based on result of other table..... Can someone help please

[Landlord_Buddy]

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