Hi All

[basha shaik]

I Have Two Date Fields

1.statrt date

2. End Date

3rd Field Count Date

 I Have Create BR on Count date.

 BR Working fine

I have write  below script scheduled job 

var gr = new GlideRecord('ast_contract');
gr.addEncodedQuery('startsISNOTEMPTY^endsISNOTEMPTY');
gr.orderByDesc('sys_updated_on');
//gr.setLimit(1);
gr.query();
while (gr.next()){
var gdt = new GlideDateTime();
gr.u_count_date = GlideDateTime.subtract(gdt, gr.getElement("ends").getGlideObject()).getRoundDayPart();
gr.update();
}

how to Decreasing count day wise 

[Anubhav24]

What is your ask here ?

[basha shaik]

 Decreasing count days

[Kavita Bhojane2]

Hello basha shaik,

Use your script in scheduled job instead of BR. Scheduled job will run daily at certain time.

Please mark my answer correct if you find it helpful.

Thanks,

Kavita Bhojane

[basha shaik]

i have write  below scheduled job script but not work please give me some inputs 

var gr = new GlideRecord('ast_contract');   //table name
gr.addEncodedQuery('startsISNOTEMPTY^endsISNOTEMPTY');
gr.orderByDesc('sys_updated_on');
//gr.setLimit(1);
gr.query();
while (gr.next()){
var gdt = new GlideDateTime();
gr.u_count_date = GlideDateTime.subtract(gdt, gr.getElement("ends").getGlideObject()).getRoundDayPart();
gr.update();
}