![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
<\/p>\n <\/p>\n
Hey, Scripting Guy! I really enjoyed the 2007 Winter Scripting Games, but one thing I noticed is that you listed the deadlines for all the events using Redmond time. I understand that you can\u2019t list deadlines using the local time for every time zone in the world; however, maybe you could show us how to write a script that could convert Redmond time to our local time. Any chance of you doing that for the 2008 Winter Scripting Games<\/b><\/a>?<\/p>\n — OD<\/p>\n Hey, OD. Considering the fact that it\u2019s been just about a year since you sent this email you might have thought, \u201cI bet the Scripting Guys forgot all about the time zone issue with the Scripting Games.\u201d Well, rest assured, OD, that the Scripting Guys rarely, if ever, forget anything. That doesn\u2019t mean that we\u2019re actually going to follow up on something; heavens no. But we won\u2019t forget about it.<\/p>\n And even if we did, the Scripting Editor would no doubt swoop down on her broomstick and offer a \u2026 gentle \u2026 reminder.<\/p>\n She\u2019s very good at that.<\/p>\n So no, we didn\u2019t forget about this question; instead, we\u2019ve been sitting on it until the time was ripe for answering it. And now that the Scripting Games are just two days away (the \u201copening ceremonies\u201d are scheduled for Friday, February 15th<\/sup>), well, the time is about as ripe as it\u2019s ever going to be.<\/p>\n So can<\/i> we show you a script that canconvert Redmond time to your local time? You know what? Not only can<\/i> we show you a script like that, we will<\/i> show you a script like that. In fact, here it is right now:<\/p>\n You know, you\u2019re right: this would have been a good event in the Scripting Games, wouldn\u2019t it? That\u2019s because it isn\u2019t particularly hard, but it is<\/i> a little bit tricky. And that\u2019s typically the type of event we like to include in the Scripting Games.<\/p>\n Oh, well. Maybe next year.<\/p>\n For now, though, let\u2019s see if we can explain how this baby works. As you can see, we kick things off by connecting to the WMI service on the local computer. Could we run this script against a remote<\/i> computer? Sure, although if that remote computer is in the same time zone as your local machine there isn\u2019t much point in running the script against a remote computer. But if you do<\/i> want to run the script against a remote machine (perhaps to help a long-distance friend convert Redmond time to their<\/i> local time) simply assign the name of the remote computer to the variable strComputer, like so:<\/p>\n After connecting to the WMI service we then use the following line of code to retrieve a collection of all the time zones that a computer belongs to:<\/p>\n Note that, in the universe we live in, a computer can belong to only a single time zone; thus this query is going to return only a single item. Could there be a parallel universe in which the accepted laws of physics don\u2019t apply and computers could<\/i> belong to more than one time zone at the same time? Hey, don\u2019t ask us; we\u2019re just Scripting Guys.<\/p>\n Incidentally, the fact that Win32_TimeZone<\/b> returns only a single item makes this class a \u201csingleton\u201d class. And yes, that would have been a good question to pose during the Scripting Games, too. Dang; if we\u2019re not careful, today\u2019s column is going to be way better and way more challenging than the actual Scripting Games!<\/p>\n Which would mark the first time this column was better than anything<\/i>.<\/p>\n After we issue our query we next set up a For Each loop to loop through each item in the collection. And yes, we know: because Win32_TimeZone is a singleton class it has only one item in it. Nevertheless, a collection is a collection, and we still have to use a For Each loop to walk through it, regardless of the number of items in that collection.<\/p>\n![\"Spacer\"](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\")
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")
![\"Script](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/ad.jpg\" "\\"Script")
<\/a> <\/p>\nstrComputer = \".\"Set objWMIService = GetObject(\"winmgmts:\\\\\" & strComputer & \"\\root\\cimv2\")Set colTime = objWMIService.ExecQuery(\"Select * From Win32_TimeZone\")For Each objTime in colTime intBias = objTime.BiasNextdtmRedmondTime = #2\/19\/2008 3:00 PM#dtmGreenwichTime = DateAdd(\"n\", 480, dtmRedmondTime)dtmLocalDeadline = DateAdd(\"n\",intBias, dtmGreenwichTime)Wscript.Echo dtmLocalDeadline<\/pre>\n
strComputer = \"atl-ws-001\"<\/pre>\n
Set colTime = objWMIService.ExecQuery(\"Select * From Win32_TimeZone\")<\/pre>\n