Further to Solution 1 - learn to use unambiguous date formats so you don't get messed up with international differences. For example 01/05/2020 is "1st May 2020" in the UK, but "5th February 2020" in the USA.
There is quite a strong statement on this here ..
SQL Server unambiguous date strings - Matt Randle[
^]
and a somewhat better discourse on why, here ..
SQL Server – Understanding Datetime column – Part II – Madhivanan's sql blog[
^]
E.g.
declare @prices table (datefrom date, dateto date, price decimal(15,2))
insert into @prices (datefrom, dateto, price) values
('2019-05-01', '2019-06-30', 50.00),
('2019-07-01', '2019-09-30', 49.00),
('2019-10-01', '2019-12-31', 48.00),
('2020-01-01', '2020-01-31', 45.00)
declare @testdate date = '2019-11-25'