i can't seem to find a solution that can allow me to delete only those rows from a data extension where "Timestamp" column has a data older than last 15 days from today and I want to do this on daily basis.
I even though about query like this
SELECT * FROM [DE_Name] WHERE 1 = 2
But i don't think this would work as it will delete all rows and i don't think i can add another condition.
Is there any way to do this by ampscript?