Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

How to update date field to current date and time

Zuri
Tera Expert

I want to run background scripts to update resolved date to current date and time

var gr = new GlideRecord('sn_customerservice_case');
gr.addQuery("sys_id","3751d2e11be113d9c4bcb7d"); 

gs.print(gr.getRowCount());
gr.query();
while(gr.next())
{

gr.state = 6 ;
//update resolved date
gr.resolved_at = (current date and time);
gr.update();

 

1 ACCEPTED SOLUTION

Nayan Mahato
Tera Guru

Hi Zuri,

Use gs.nowDateTime();

 

var gr = new GlideRecord('sn_customerservice_case');

gr.addQuery("sys_id","3751d2e11be113d9c4bcb7d");

gs.print(gr.getRowCount());

gr.query();

while(gr.next()){

gr.state = 6 ;

//update resolved date

gr.resolved_at = gs.nowDateTime();

gr.update();

 }

Regrads,

Nayan

 

 

 

View solution in original post

1 REPLY 1

Nayan Mahato
Tera Guru

Hi Zuri,

Use gs.nowDateTime();

 

var gr = new GlideRecord('sn_customerservice_case');

gr.addQuery("sys_id","3751d2e11be113d9c4bcb7d");

gs.print(gr.getRowCount());

gr.query();

while(gr.next()){

gr.state = 6 ;

//update resolved date

gr.resolved_at = gs.nowDateTime();

gr.update();

 }

Regrads,

Nayan