Report for financial year

[Nikithesh R]

Hello All,

I have to create report incidents open in financial year. Kindly help me out how to create filter.

Thanks.

[Ankur Bawiskar · Accepted solution]

@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.

[Nikithesh R]

Got it. Thank you @Ankur Bawiskar