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.

[Javier C_]

Hey  guys,

Thanks for sharing! the code worked. It took me some trial and errors but here's what finally worked for me

var ad = new GlideRecord('YOUR_TABLE');
ad.query();
while(ad.next()){
ad.start_date_01 = ad.status_date.getDisplayValue();
ad.update();
}

Again, the answer was already provided here in this forum but i wanted to shave 5 minutes of your code time if this could help out.