Sript to Remove Records created on a specific date

[carlh]

Can anyone provide a script to remove records created on a specific date?

Something went wrong today and we ended up with Duplicates of all records on our vendor table.

I need a script that will delete all records created on 7/28/2016 in Core_Company table.

Please let me know and thanks!

[carlh]

got it.

so now I can run the first script provided and it will delete those?  

[carlh]

do I need to add the " gr.query();" in the script to delete now that the count looks right?

[Abhinay Erra]

Nope you do not need .query()

[Pradeep Sharma · Accepted solution]

Hi Carl,

Slight modification to the script shared by Abhniay. Enclosed code in function and added setWorkflow line to turn of notification/BR

Script :

delCoreCompanyRec();
function delCoreCompanyRec()
{
var gr= new GlideRecord("core_company");
gr.addEncodedQuery("sys_created_onON2016-07-28@javascript:gs.dateGenerate('2016-07-28','start')@javascript:gs.dateGenerate('2016-07-28','end')");
gr.setWorkflow(false); //Don't fire Business rule,notifications
gr.deleteMultiple();
}

[carlh]

Results from Pradeep