MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Create Table items(item_id INT, date DATE, item_price INT);

Insert Into items Values(1,'2022-12-05',15),
(2,'2022-02-14',12),
(1,'2022-11-12',50),
(4,'2022-01-21',13),
(1,'2021-12-12',10),
(6,'2021-12-27',83);

Records: 6  Duplicates: 0  Warnings: 0


Create Procedure GetLatesPrice(id INT, period INT, interval_type Varchar(1)) 
Begin
  Select item_id, date, item_price
  From
  (
    Select *, 
      Case 
       When interval_type='d' Then
        Max(
             Case 
               When date Between DATE_SUB(CURDATE(), INTERVAL period Day) And CURDATE() 
               Then date 
             End
           ) Over (Partition By item_id)
        When interval_type='m' Then
         Max(
             Case 
               When date Between DATE_SUB(CURDATE(), INTERVAL period Month) And CURDATE() 
               Then date 
             End
            ) Over (Partition By item_id)
        When interval_type='d' Then
         Max(
             Case 
               When date Between DATE_SUB(CURDATE(), INTERVAL period Year) And CURDATE() 
               Then date 
             End
            ) Over (Partition By item_id)
       End As last_price_date
   From items
  ) T
  Where date = last_price_date And item_id=id;
END 
Call GetLatesPrice(1, 15, 'd'); -- d for days, m for months, y for years


item_id
date
item_price


1
2022-12-05
15