ODBC guide

Delete list members (archive) by date


Archives list members that opted in after a specific date using DELETE FROM ListMembers WHERE TimestampOpt > '...' WITH (ListId='...'). For permanent delete, use the permanent delete operation instead.

DELETE from ListMembers 
WHERE TimestampOpt > '2023-06-16' 
WITH (ListId='a4d24015f8')