Is it possible to get all records created on the month before last month?

[Serhii5]

Hi guys, is it possible to query all records created on the month before last month? 

Regards, Serhii

[Ankur Bawiskar · Accepted solution]

Hi,

The filter condition shared by Dhananjay should work.

Reference below

Script also gives 16 count:

var gr=new GlideRecord('incident');

gr.addEncodedQuery('sys_created_on<javascript:gs.beginningOfLastMonth()^sys_created_on>javascript:gs.beginningOfLast60Days()');

gr.query();

gs.info(gr.getRowCount());

Thanks
Ankur

[Dhananjay Pawar]

Hi,

var gr=new GlideRecord('table-name');

gr.addEncodedQuery('sys_created_on<javascript:gs.beginningOfLastMonth()^sys_created_on>javascript:gs.beginningOfLast60Days()');

gr.query();

while(gr.next()){

gs.addInfoMessage(gr.number);//Change to correct field or you can add your logic here.

}

Mark correct/helpful based on impact.

Thanks,

Dhananjay.

[Dhananjay Pawar]

Hi,

gr.addEncodedQuery('sys_created_on<javascript:gs.beginningOfLastMonth()^sys_created_on>javascript:gs.beginningOfLast60Days()');

lets say you are in July and you want May records then above query will do trick for you.

Thanks,

Dhananjay.

[Dhananjay Pawar]

Hi,

If this has resolved kindly mark this as correct so others will refer same in future and by marking this as correct question will remove from unanswered thread.

Thanks,

Dhananjay.

[Dhananjay Pawar]

Hi Serhii,

I believe the answer you have marked correct is already provided by me. I will appreciate if you mark my response as correct.

Thanks,

Dhananjay.