Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Why getDate() is not working properly?

Vasu ch
Kilo Sage

Hi all,

I've a requirement where I have to capture the record created date in another field without time attached. Simply, in OOB we have Created field which stores record created date and time as well. But I just need to capture the record created date without time in another field.

I've created the following script to capture the date in new field(u_created_date) which is a Date type field.

while(gr.next()){
    var caseCreationDate = gr.getValue("sys_created_on");
    var gd = new GlideDateTime(caseCreationDate);
    gr.setValue("u_created_date",gd.getDate());
    gr.update();
}

 

On executing the above script only some fields are giving me the right date. Some fields are giving wrong date.

 

find_real_file.png

Why it is happening like that?

12 REPLIES 12

@Vasu ch 

If your query is resolved then close the thread by marking appropriate response as correct.

Regards
Ankur

 

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi Vasu,

How did you implement your requirement? I'm now into the same issue as you.

Thank you.

Hi,

For the field I've created, I just added some script in calculation. Ref below

find_real_file.png