Bring value from another table that is between two dates

I am working on a project where I have two tables   Table1 is transaction data and contains a specific date of transaction.  i.e.   Customer Item Date Walmart Funyuns 1/13/2023    ...