Timezone getting changed automatically after clicking on Complete import.

Aakanksha Kotti
Tera Contributor

‎12-22-2022 12:44 AM

Hi All,

We are having customer requirement where we have to update the calendar. For this we are importing the excel into Service Now. The issue we are facing right now is mentioned below:-

 

1) Whenever we are importing the excel and selecting to preview the record, it is showing the correct start and end date time.

AakankshaKotti_0-1671698483958.png

2)But after clicking on the 'Complete import', it is showing the different start and end date time. 

AakankshaKotti_1-1671698589301.png

Anyone knows hoe to fixed this?

 

Thank you.

 

0 Helpfuls
  • 460 Views
1 REPLY 1

Community Alums
Not applicable

‎12-22-2022 12:47 AM

Hi @Aakanksha Kotti ,

Check any data sources that are feeding your User (sys_user) table like AD, note if they are importing or setting the timezone I think the user timezone would have been changed because the AD data has been sync with ServiceNow.

Sometimes the timezone would have been changed if the User location has been changed .

Example : US ( EST ) then user location change to India(IST) .

 

0 Helpfuls