I have an sql table and a number of columns.
One of the columns stores dates in the format yyyy-mm-dd. I need to delete records that are older than 10 days.
I’ve tried numerous ways but can’t get it to work using a query.
Assume the ‘?’ is a date in format yyyy-mm-dd below and ‘dateF’ is the column holding the dates.
sqlList =  sqlList = ["DELETE FROM Stats WHERE CAST(dateF as datetime) < ?;", args, DeleteS, DeleteF] Sql(DB1, sqlList)
Any help is greatly appreciated.