@Nikithesh R
something like this, I hope this will help and you will be able to take it from here
var gr = new GlideRecord('sys_report');
gr.addQuery('sys_id','b44000f283290210a38da9e0deaad319');
gr.query();
if(gr.next())
{
var gdt = new GlideDateTime();
var currentYear = gdt.getYearLocalTime();
var nextYear = currentYear + 1;
var juneDate = currentYear + "-06-01"; // date is in YYYY-MM-dd format
var nextYearMayDate = nextYear + "-05-31"; // date is in YYYY-MM-dd format
var query = "sys_created_onBETWEENjavascript:gs.dateGenerate('" + juneDate + "','" + "00:00:00" + "')@javascript:gs.dateGenerate('" + nextYearMayDate + "','" + "00:00:00" + "')";
gr.filter = query;
gr.update();
}
If my response helped please mark it correct and close the thread so that it benefits future readers.
Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
