Get the total number of incidents opened over last 6 months excluding weekends.

[deepthireddy]

Hi everyone,

Just one small help and I'm not sure of the right approach.

I want to pull out the total number of incidents opened in the last 6 months without including weekends i.e. Saturday and Sunday. Current filter conditions do not show this option. Anybody tried this and can help me out?

Thanks a ton,

Deepthi

[Shishir Srivast]

we can something like this,

var gr = new GlideRecord('incident');

gr.addQuery('sys_created_on', '>=' , 'javascript:gs.daysAgo(180)');

gr.query();

while(gr.next()){

var dt = new GlideDateTime(gr.sys_created_on);

var dow = dt.getDayOfWeek();

if(dow!=6 && dow!=7){

gs.print(gr.number);

}

}

[Deepak Ingale1]

Hi Deepthi,

You can do it via simple filter conditions without any script

[deepthireddy]

Deepak,

Awesome ! this helps

[adamjgreenberg]

You can further simplify this query: