to ensure that published Knowledge Articles with a "valid to" date of before today are made inactive.

[Mad3]

Can help when I access a Knowledge Base and all articles displayed have a 'valid to' date after today should be inactive.

[Harish KM]

var nowDate = new GlideDate().getDisplayValue();
var gr = new GlideRecord('kb_knowledge');

gr.addQuery('kb_knowledge_base',   'sysID of knowledgebase'); //you can add knowledge base sysid here 
gr.addQuery('valid_to',  '<', nowDate);
gr.query();
while(gr.next()){
gr.setValue('active', false);
gr.update();
}

[Mad3]

In that case we have 2 knowledge bases. So how can add 2 sys id's of knowledge base.

[Harish KM · Accepted solution]

In that case you can use encodedQuery.

var query = 'kb_knowledge_base=a7e8a78bff0221009b20ffffffffff17^ORkb_knowledge_base=862c887e07d20110f1cbf48f7c1ed0c5';

var nowDate = new GlideDate().getDisplayValue();
var gr = new GlideRecord('kb_knowledge');

gr.addEncodedQuery(query); //you can add knowledge base sysid here 
gr.addQuery('valid_to',  '<', nowDate);
gr.query();
while(gr.next()){
gr.setValue('active', false);
gr.update();
}

Refer screenshot to run query

[Mad3]

Thanks Harish,

that really helped me.

[Aman Kumar S]

Hey,

You can follow below article to understand the working of Valid to:

For knowledge articles, what will happen after the “valid to “date is passed?

Feel free to mark correct, If I answered your query.

Will be helpful for future visitors looking for similar questions 🙂