@Kani Yes...I have similar use case where i run a sql query with filter start date and end_date and job has to run in every 10days 

Current run > select * from table where start_date > 01-01-2024 and end_date < 01-10-24  

Now if job is succsful in nect run it should pick > Select * from table where start_date > 01-10-24 and end_date < 01-20-24

Workflow should automatically take these dates on execution