I have a module in which I import #rows of data for previous day
I want to hold only 5 days of data.
Everyday I want to delete earliest date #rows to ensure I hold only 5 days data
Appreciate your input.
Agreed - that seems the most sensible.
I have a different approach from @andrewtye @nikolay_denisov , Please suggest if this approach has a particular issue .
In this approach you wont be required to do current date hustle.
Add 3 line items to your module