Date time error while importing

[Pavan S]

Hi.

Iam using transform map for importing the holidays list (from excel) into ServiceNow.

But while importing the start date timing is getting changed to 18:30:00 instead of 00:00:00.

The start date time iam importing from excel 

The date it is updating in ServiceNow 

i have tried the onBefore and onAfter scripts but still it didn't work. Also tried to change my Time zone or excel time zone but still it didn't work.

Can anyone help me about how to update the exact time mentioned in the excel sheet. (i have done the same thing from past 3 years bit it worked. Now only facing the issue)

[Ankur Bawiskar]

@Pavan S 

Hope you are doing good.

Did my reply answer your question?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏