Change Timezone from UTC to EST

[besakkiappan46]

Hi ,
I need help in converting a string value in yyyy-MM-dd HH:mm:ss format to EST time zone by retaining the same format.

Thanks in advance

[Ajay_Mishra (Ajay Mahendra Mishra)]

@besakkiappan46

I need help in converting a string value in yyyy-MM-dd HH:mm:ss format to EST time zone by retaining the same format.

Hey @besakkiappan46

1st Assign:

Input_DateTime = DateTime.ParseExact(str_InputDate,"yyyy-MM-dd HH:mm:ss",System.Globalization.CultureInfo.InvariantCulture)

2nd Assign:

Output_DateTime = TimeZoneInfo.ConvertTimeFromUtc(Input_DateTime,TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time"))

Screenshot for your reference:

Variable Panel:

Output Panel:

Regards,
Ajay Mishra

[besakkiappan46]

@Ajay_Mishra Everything is fine. But Just one question. I have AM/PM at the end of the Str_InputDate after the seconds. It throws error. is there a way to convert the string ( yyyy-MM-dd HH:mm:ss am) to Datetime? or should I go for substring and ignore AM/PM at the end?

[Ajay_Mishra (Ajay Mahendra Mishra)]

@besakkiappan46 Add tt
If AM/PM is in capital letters then:
yyyy-MM-dd HH:mm:ss tt

That’s it!

Regards,
Ajay Mishra

[besakkiappan46]

Thank you so much @Ajay_Mishra

[Ajay_Mishra (Ajay Mahendra Mishra)]

@besakkiappan46 Your Welcome

Happy Automation!

Best Regards,
Ajay Mishra