How to convert a dateTime variable to Mountain Date Format (MT)?

[laraiv.khan]

Basically, I want to convert the UTC date time to MT date time format. Any Leads?

[RajKumar_DC (RajKumar Durai)]

Hi @laraiv.khan ,

1. Use the ParseExact method of the DateTime structure to parse the dateTime variable using the original date format. For example, if the original date format is “MM/dd/yyyy hh:mm:ss tt”, you can use the following expression:dateTime = DateTime.ParseExact(dateTimeString, "MM/dd/yyyy hh:mm:ss tt", CultureInfo.InvariantCulture)where dateTimeString is the string representation of the dateTime variable.
2. Set the time zone of the dateTime variable to Mountain Standard Time (MST) using the TimeZoneInfo.ConvertTime method. For example, if you want to convert to Mountain Daylight Time (MDT), you can use the following expression:dateTime = TimeZoneInfo.ConvertTime(dateTime, TimeZoneInfo.FindSystemTimeZoneById("Mountain Standard Time"), TimeZoneInfo.FindSystemTimeZoneById("Mountain Daylight Time"))
3. Convert the dateTime variable back to a string representation using the desired format. For example, if you want to use the format “MM/dd/yyyy hh:mm:ss tt”, you can use the following expression:dateTimeString = dateTime.ToString("MM/dd/yyyy hh:mm:ss tt")

Thanks,

[arjunshenoy]

Hi @laraiv.khan, welcome back to the Community.

The following thread has the discussion related to the conversion of UTC to a specified timezone:

Solution on how to convert DateTime variables between UTC and Local or a specific timezone

Convert from UTC to a specified timezone. We can use the TimeZoneInfo.ConvertTimeFromUtc static method in an Assign activity (Invoke Method can work as well), setting first parameter to the UTC DateTime object and the second parameter to a TimeZoneInfo object which represent the target Timezone. The TimeZoneInfo object can be created with the help of TimeZoneInfo.FindSystemTimeZoneById method where we need to specify the name of the timezone we want, like India Standard Time or Tokyo Standard…

Hope this helps.
Best Regards.

[laraiv.khan]

Thanks @RajKumar_DC