Hello This code will return -04:00 while my time zone is set to -05:00 Also, to show the -05:00 like -0500 is there a specific formatter? Thanks :) DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss zzz")

Hi,@ StewartBW. Welcome to Microsoft Q&A. In VB, you could achieve this by using DateTimeOffset to ensure that the correct time zone offset is used and then format the output string accordingly. Dim now As DateTimeOffset = DateTimeOffset.Now Dim formattedDate As String = now.ToString("ddd, dd MMM yyyy HH:mm:ss zzz") ' Replace the colon in the time zone offset with nothing formattedDate = formattedDate.Replace(":", "") Console.WriteLine(formattedDate) If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Format DateTime TimeZone

Accepted answer

Hui Liu-MSFT 48,571 Reputation points Microsoft Vendor

2024-07-31T12:40:31.6933333+00:00
Hi,@ StewartBW. Welcome to Microsoft Q&A.

In VB, you could achieve this by using DateTimeOffset to ensure that the correct time zone offset is used and then format the output string accordingly.

Dim now As DateTimeOffset = DateTimeOffset.Now Dim formattedDate As String = now.ToString("ddd, dd MMM yyyy HH:mm:ss zzz") ' Replace the colon in the time zone offset with nothing formattedDate = formattedDate.Replace(":", "") Console.WriteLine(formattedDate)

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

1 person found this answer helpful.
StewartBW 1,145 Reputation points

2024-07-31T15:04:08.2733333+00:00

Is this normal? :(

Hui Liu-MSFT 48,571 Reputation points Microsoft Vendor

2024-08-02T08:34:34.3066667+00:00

Hi,@ StewartBW. DateTimeOffset includes both the local date and time as well as the offset from UTC. The -0400 indicates the offset from UTC, which is typically used in Eastern Daylight Time (EDT).

The discrepancy between -0400 and UTC-05:00 might be due to daylight saving time (DST). EDT (-0400) is used during the summer months, while Eastern Standard Time (EST, -0500) is used during the rest of the year.

If you want to set or convert to a different time zone, you could use TimeZoneInfo and TimeZoneInfo.BaseUtcOffset Property.

Dim now As DateTime = DateTime.Now Dim est As TimeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("Eastern Standard Time") Dim easternTime As DateTimeOffset = TimeZoneInfo.ConvertTime(now, TimeZoneInfo.Local, est) Dim estOffset1 As TimeSpan = est.BaseUtcOffset Dim formattedEasternTime As String = easternTime.ToString("ddd, dd MMM yyyy HHmmss ") & " " & est.BaseUtcOffset.ToString("hh\:mm") MessageBox.Show(formattedEasternTime)
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Format DateTime TimeZone

0 additional answers

Your answer