Need SQL Logic to get data from last bip report scheduled date
We have requirement to get report output from sysdate to last report scheduled date.
for example, if report is first scheduled on Jan 1st 2025 and later schedule date is Jan 15th 2025. I need data from 1 Jan 2025 to 15 Jan 2025.
So, is there any SQL logic to get that data.