Take it away, Brian …<\/p>\n
It’s that time of year where most of us, in the United States, “gain” an hour of sleep by setting our clocks back one hour. I’ve been getting emails and comments about a Windows PowerShell function I created called Get-DSTInfo<\/b>, which queries the Win32_TimeZone WMI Class to determine when the system “thinks” it needs to perform those automated changes. It’s that time of year where the IT community is looking for ways to ensure their systems are going to behave as expected. I’m always excited to see people in the world use some of the tools I create. For more information, see my previous Hey, Scripting Guy! Blog entry<\/a> introducing this function.<\/p>\n Following is an image of what the output looks like when Get-DSTInfo<\/b> runs locally.<\/p>\n Recently, I received some feedback from Justin Moore that my function didn’t display the DaylightChgDate<\/b> and StandardChgDate<\/b> Date\/Time correctly for the Central Europe Time Zone. To learn more, we will need to dig into the Win32_TimeZone WMI Class. This class has the following information, which my function uses to calculate the actual date.<\/p>\n The command is shown here.<\/p>\n Get-CimInstance Win32_TimeZone | select *<\/p>\n The command and the output from the command are shown in the following image.<\/p>\n You’ll notice that the actual dates of the time changes are not present. However, what we do have is the StandardDay<\/b> property, which means the First<\/b>, Second<\/b>, Third<\/b>, Fourth<\/b>, or Last<\/b> day that the time changes. <\/p>\n Here, in the United States, we will set our clocks back one hour on the first Sunday in November. In this case, the StandardDay<\/b> property equals 1<\/b>, meaning the First<\/b> in “First <\/b>Sunday of November.” The switch statement, shown below, highlights this concept.<\/p>\n Switch ($TimeZone.StandardDay)<\/p>\n {<\/p>\n 1 {$STNDDay = “First”}<\/p>\n 2 {$STNDDay = “Second”}<\/p>\n 3 {$STNDDay = “Third”}<\/p>\n 4 {$STNDDay = “Fourth”}<\/p>\n 5 {$STNDDay = “Last”}<\/p>\n }#End Switch ($TimeZone.StandardDay) <\/p>\n Next, let’s take a look at the StandardDayOfWeek<\/b> property, which means the day of the week the time change will occur. In the image above, it equals 0<\/b>, which means Sunday<\/b> in “First Sunday<\/b> of November.” The switch statement follows.<\/p>\n Switch ($TimeZone.StandardDayOfWeek)<\/p>\n {<\/p>\n 0 {$STNDWeek = “Sunday”}<\/p>\n 1 {$STNDWeek = “Monday”}<\/p>\n 2 {$STNDWeek = “Tuesday”}<\/p>\n 3 {$STNDWeek = “Wednesday”}<\/p>\n 4 {$STNDWeek = “Thursday”}<\/p>\n 5 {$STNDWeek = “Friday”}<\/p>\n 6 {$STNDWeek = “Saturday”}<\/p>\n }#End Switch ($TimeZone.StandardDayOfWeek)<\/p>\n Finally, let’s review the StandardMonth<\/b> property, which means the month the time change will occur, which, in this example, is 11<\/b> for November<\/b> in “First <\/b>Sunday of November<\/b>.”<\/p>\n Switch ($TimeZone.StandardMonth)<\/p>\n {<\/p>\n 1 {$STNDMonth = “January”}<\/p>\n 2 {$STNDMonth = “February”}<\/p>\n 3 {$STNDMonth = “March”}<\/p>\n 4 {$STNDMonth = “April”}<\/p>\n 5 {$STNDMonth = “May”}<\/p>\n 6 {$STNDMonth = “June”}<\/p>\n 7 {$STNDMonth = “July”}<\/p>\n 8 {$STNDMonth = “August”}<\/p>\n 9 {$STNDMonth = “September”}<\/p>\n 10 {$STNDMonth = “October”}<\/p>\n 11 {$STNDMonth = “November”}<\/p>\n 12 {$STNDMonth = “December”}<\/p>\n }#End Switch ($TimeZone.StandardMonth)<\/p>\n The fun part of Windows PowerShell scripting is figuring out, with the above information, how to calculate the date, so let’s break the code down.<\/p>\n Below, I’m grabbing the current year to work from.<\/p>\n $CurrentYear = (Get-Date).Year<\/p>\n Next, using the information from the switch statements, I’m going to cast the data into a DateTime<\/strong> object. For example, $SDate<\/b> would equal Thursday, November 1, 2012 2:00:00 AM<\/b>:<\/p>\n [DateTime]$SDate = “$STNDMonth 01, $CurrentYear $STNDHour`:00:00”<\/p>\n We are now going to use a While loop to determine and calculate the actual change date. I’m going to set $i <\/b>to 0 <\/b>and run the While loop as long as $i<\/b> is less than $TimeZone.StandardDay<\/b>. The first If Statement checks to see if the $SDate.DayOfWeek<\/b> equals the $TimeZone.StandardDayOfWeek<\/b>. If not, we will add a day to the $SDate<\/b> variable and continue to do so until $SDate.DayOfWeek<\/b> equals StandardDayOfWeek<\/b>. <\/p>\n If you’ve successfully followed along, we started out with November 1, 2012<\/b> as the $SDate<\/b> and continued to add days until reaching November 4, 2012 <\/b>since the first If Statement is now true, If ($SDate.DayOfWeek -eq $TimeZone.StandardDayOfWeek)<\/b>. The reason for this is because November 4, 2012 <\/b>is on a Sunday and the $TimeZone.StandardDayOfWeek<\/b> also equals Sunday 0<\/b>. <\/p>\n At the moment, we’ve incremented $i<\/b> by 1<\/b> and $SDate<\/b> equals November 4, 2012<\/b>, <\/b>and we will use the second If Statement If ($i -eq $TimeZone.StandardDay)<\/b> to test if $i<\/b> equals $TimeZone.StandardDay<\/b>. In this case, it does, so we’ll assign $SFinalDate<\/b> = $SDate<\/b> (November 4, 2012<\/b>).<\/p>\n $i = 0<\/p>\n While ($i -lt $TimeZone.StandardDay)<\/p>\n {<\/p>\n If ($SDate.DayOfWeek -eq $TimeZone.StandardDayOfWeek)<\/p>\n {<\/p>\n $i++<\/p>\n If ($i -eq $TimeZone.StandardDay)<\/p>\n {<\/p>\n $SFinalDate = $SDate<\/p>\n }#End If ($i -eq $TimeZone.StandardDay)<\/p>\n Else<\/p>\n {<\/p>\n $SDate = $SDate.AddDays(1)<\/p>\n }#End Else<\/p>\n }#End If ($SDate.DayOfWeek -eq $TimeZone.StandardDayOfWeek)<\/p>\n Else<\/p>\n {<\/p>\n $SDate = $SDate.AddDays(1)<\/p>\n }#End Else<\/p>\n }#End While ($i -lt $TimeZone.StandardDay)<\/p>\n Back to the reason why this doesn’t work with the Central Europe Time Zone … as you can see in the following image, the StandardDay<\/b> equals Last<\/b> or 5<\/b>. This will be an issue if there are only four Sundays in October, because according to the MSDN Win32_TimeZone reference<\/a>, last equals 5. In this case, the loop logic will run through five times and will match the fifth Sunday of October to November 4, 2012<\/b>, which, obviously, is incorrect because there are only four Sundays in October this year.<\/p>\n I thought for a minute and came up with this solution.<\/p>\n If ($SFinalDate.Month -ne $TimeZone.StandardMonth)<\/p>\n {<\/p>\n $SFinalDate = $SFinalDate.AddDays(-7)<\/p>\n }#End If ($SFinalDate.Month -ne $TimeZone.StandardMonth)<\/p>\n The above code is placed just after the loop, and it will evaluate whether the loop landing date “month” matches the month the Win32_TimeZone information returns. If they do not match, it will set the $SFinalDate back seven days so that the date will be correct. Therefore, handling either condition for 4<\/b> or 5<\/b> for StandardDay<\/b> will calculate the date correctly.<\/p>\n I have updated the function, and it is currently available in the Script Repository on TechNet<\/a>.<\/p>\n I hope you’ve enjoyed exploring Windows PowerShell with me today. Until next time …<\/p>\n Thank you, Brian, for sharing this update with us. Awesome job.<\/p>\n Join me tomorrow when we will have another guest blogger.<\/p>\n I invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n Ed Wilson, Microsoft Scripting Guy<\/b><\/p>\n","protected":false},"excerpt":{"rendered":" Summary: Brian Wilhite, guest blogger, discusses a function to check for transition to daylight savings time. Microsoft Scripting Guy, Ed Wilson, is here. Today, we have a guest blogger. Brian Wilhite has been a guest in the past, and you can see his previous posts here. Brian is speaking at the Atlanta Windows PowerShell Saturday […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[327,56,3,45],"class_list":["post-4784","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-brian-wilhite","tag-guest-blogger","tag-scripting-guy","tag-windows-powershell"],"acf":[],"blog_post_summary":" Summary: Brian Wilhite, guest blogger, discusses a function to check for transition to daylight savings time. Microsoft Scripting Guy, Ed Wilson, is here. Today, we have a guest blogger. Brian Wilhite has been a guest in the past, and you can see his previous posts here. Brian is speaking at the Atlanta Windows PowerShell Saturday […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/4784","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=4784"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/4784\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=4784"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=4784"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=4784"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/2806.hsg-10-23-12-1.png\" "\\"Image")
<\/a><\/p>\n![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/5023.hsg-10-23-12-2.png\" "\\"Image")
<\/a><\/p>\n![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/0066.hsg-10-23-12-3.png\" "\\"Image")
<\/a><\/p>\n