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