Set records inactive when end date is reaches

[msc]

Hi everyone,

I have a requirement that I need to inactive records based on end date.

When end date is reached then I have to inactive the record itself.

Could you please help me on this requirement.

[Anurag Tripathi]

I would suggest a scheduled job for this.

You can run the job once a day in non business hours, and close out all the records where end date is today (or Yesterday)

[Dr Atul G- LNG]

Hi @msc 

Something similar 

https://www.servicenow.com/community/developer-forum/incident-management-i-need-a-background-script-...

https://www.servicenow.com/community/itsm-forum/setting-incident-to-active-false/m-p/2570308

[SP22]

Hi @msc ,

Please find the below script and let me whether it is useful or not.

// Create a GlideRecord query for the table (for example, 'incident')
var gr = new GlideRecord('incident');
gr.addQuery('active', true); // Filter for active records
gr.addQuery('end_date', '<=', gs.nowNoTZ()); // Filter for records where end date is in the past or present
gr.query(); // Execute the query

while (gr.next()) {
    gr.setValue('active', false); // Set active field to false for those records
    gr.update(); // Update the record
    gs.info('Record marked inactive: ' + gr.number); // Log the record number for reference
}

Thanks
SP

[Ankur Bawiskar]

@msc 

I would recommend flow for this with no-code, low-code approach

I shared something similar earlier, just enhance it for your case

1) Flow Trigger Daily 23:00:00

2) Use Lookup Records action on your table to check if end date is today

3) Then use For Each to iterate over those records

4) then use Send Email action (You use Update Record action)

If my response helped please mark it correct and close the thread so that it benefits future readers.