Fix Script to copy date from a Datetime field to a Date field for all records in the table.

[prabhmeet2]

Hi,

This is a scenario of my request.

Incident table has a field Opened - which is date time field. I have to create a new field on Incident table my_Opened and its should be date field and I have to create a fix script to copy only the date values for all records from "opened" to "my_Opened" field.

1. To create a new column, I did through configure dictionary, is that correct?

2. I have written the below fix script but the dates are increasing by 1- 

var gr = new GlideRecord('incident');

gr.query();
while(gr.next()){

gr.u_my_opened = gr.opened_at;
gr.setWorkflow(false);
gr.update();

The dates in my_opened are increasing by 1, screenshot attached.

Can someone please help.

[Mark Roethof]

Hi there,

This is not occurring for all dates I see. How about your timezone setting on your system? Is their a difference in that?

I think the time difference is the issue. Let me test.

Kind regards,
Mark

---

LinkedIn

[Mark Roethof]

Aaaahhhh I take it back... just tested your exact code on my PDI: No issues.

If you compare one of the wrong records on XML level, how do the dates look like then?

Kind regards,
Mark

---

LinkedIn

[prabhmeet2]

Hi Mark,

Thanks, it worked by using getDisplayValue()

[vkachineni]

try

gr.u_my_opened = gr.opened_at.getValue();