Read Dynamically from SQL/File_Date

[Dhruv_001]

Hi All,

I have daily files in my SQL table with daily dates. I am pulling my current date file and last 6 days files separately from SQL.

 Current Date Data + Last 6 Days Data. (it is a condition) which is treated as a single file.

However, I want to make it dynamic for my multiple files in SQL. Now I want to run for last 2023 year data. How can I make it dynamic?

The result should be picking files like this :

1. 13th Sep 2023 file + (last 6 days files: 12th,11th,10th,9th,8th,7th Sept) 

2. 12th Sep 2023 file + (last 6 days files: 11th,10th,09th,8th,7th,6th Sept) 

....................................................................................................

Any ideas / suggestions ?