Why getDate() is not working properly?

[Vasu ch]

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.

Why it is happening like that?

[Ankur Bawiskar]

Hi,

try to identify which records are being shown with the previous day date?

Regards
Ankur

[Vasu ch]

It seems I'm getting such issues for the records which are created before 12:31 or some more time. Please have a look at below pics.

[Ankur Bawiskar]

that might be the pattern

try this

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

Regards
Ankur

[Vasu ch]

Hi Ankur,

Thanks for your time. I've implemented my requirement using Calculate value related list method.

[Ankur Bawiskar]

@Vasu ch 

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

Regards
Ankur