Turducken Bowl<\/B><\/A> is upon us.<\/P>\nOn the off-chance that some of you have never heard of the annual Turducken Bowl, a few years ago the Scripting Guy who writes this column, the Scripting Son, and a pair of Scripting Nephews played a very spirited (and bruising) game of touch football on Thanksgiving Day. What started out as a way to pass the time until we could (finally!) sit down to eat has now become a holiday tradition: four downs to go the length of whatever field we\u2019re playing on; 7 points per touchdown; first team to score 100 points wins. As is the case with most family activities, there is considerable controversy over which team holds the upper hand. As far as the Scripting Guy who writes this column is concerned, his team trails 4 wins to 3.<\/P>\n
So how did last year\u2019s game go? Well, remember, the important thing isn\u2019t whether you win or lose; the important thing is just the sheer joy of taking part. Not that the Scripting Guy who writes this column actually experienced any<\/I> kind of joy last year, let alone sheer joy. How did last year\u2019s game go? Let\u2019s put it this way: on the opening play of the game, the Scripting Guy who writes this column went out for a pass. His Scripting Nephew teammate, playing quarterback, flung the ball downfield, only to have the wind grab hold of the football and carry it over the fence and into the neighbor\u2019s backyard.<\/P>\n
Believe it or not, things actually got worse<\/I> after that.<\/P>\n
Unfortunately, things don\u2019t promise to go much better this year. Due to some weird bureaucratic procedures that the Scripting Guy who writes this column doesn\u2019t even pretend<\/I> to understand, it was decided that this year the team rosters would be expanded by one player each. The Scripting Son and the Scripting Nephew (the nephew who didn\u2019t<\/I> throw a football over the fence), who won last year\u2019s game in a rout, get to add one of the Scripting Brothers, a Scripting Brother who\u2019s actually pretty good at football. In return, the Scripting Guy who writes this column and the Script Nephew (the one who did<\/I> throw a football over the fence) get to add \u2026 one of the Scripting Significant Others. Is that a fair deal? Let\u2019s put it this way: that\u2019s about as fair as \u2013<\/P>\n
You know what? Maybe we shouldn\u2019t put it that way after all. Instead, maybe we should just keep quiet and not get ourselves into any further trouble.<\/P>\n
Besides, we can always hope that the Significant Other breaks her leg before the game starts.<\/P>\n
Just kidding, dear. No one wants you to break your leg.<\/P>\n
A twisted or sprained ankle would work just fine.<\/P>\n
Anyway, the Scripting Guy who writes this column is busy trying to come up with a game plan that will help his team pull off the upset of the century. Has he come up with anything yet? No, not yet, or at least not anything that doesn\u2019t involve kidnapping all the players on the other team. And even then<\/I> he\u2019s not convinced that his team could win.<\/P>\n
One of the strategies the Scripting Guy who writes this column briefly considered was to write a script that could tell whether a specified time occurred in the evening or the afternoon. He discarded that strategy after he had trouble figuring out how that would help him win a football game. On the bright side, however, (and trust us, some of us are desperately searching for a bright side to all this) that strategy did<\/I> help him to answer today\u2019s question:<\/P>dtmTime = #11\/21\/2007 1:57 PM#<\/p>\nintHour = Hour(dtmTime)<\/p>\n
If intHour > 11 Then\n Wscript.Echo “This is an afternoon\/evening time.”\nElse\n Wscript.Echo “This is a morning time.”\nEnd If\n<\/PRE>\n
You\u2019re right: this is<\/I> a very simple little script, isn\u2019t it? (And it\u2019s merely a coincidence that the Scripting Guy who writes this column picked a question that could be answered with a simple little script on the one day that he gets to leave work as soon as the column is done.) The script starts out by assigning a date-time value to a variable named dtmTime; in case, you\u2019re wondering, the pound signs (#) that surround the value tell VBScript that this is a date-time value and not some other type of value:<\/P>dtmTime = #11\/21\/2007 1:57 PM#\n<\/PRE>\nSo how do we know whether this time occurred in the morning (i.e., before 12:00 noon) or in the afternoon\/evening (i.e., after<\/I> 12:00 noon)? Well, we<\/I> can do that easily enough; after all, we can see the PM<\/I> designator stuck on the end. But how is the script<\/I> supposed to know if this is a morning or evening time?<\/P>\n
Here\u2019s how:<\/P>
intHour = Hour(dtmTime)\n<\/PRE>\nAll we\u2019re doing here is using the Hour<\/B> function to grab just the hour portion of our date-time value. The Hour function returns an integer value between 0 and 23, representing the hour in 24-hour time; in our sample script, that means we\u2019ll get back a 13 (because, in the 24-hour format, 1:57 PM is equivalent to 13:57). All we have to do then is determine whether the hour value we got back is greater than 11:<\/P>If intHour > 11 Then\n<\/PRE>\nIf this is true (that is, if the hour is between 12 and 23, inclusive) then we echo back the fact that we have an afternoon\/evening time. If this is false (that is, if the hour is between 0 and 11, inclusive) then we echo back the fact that this is a morning time. That\u2019s all we have to do.<\/P>\n
If only figuring out a way to win a football game was that easy, huh?<\/P>\n
The nice thing about using this approach is that it will work regardless of the time format we\u2019re using. For example, suppose we assigned a date-time value to the variable dtmTime using this<\/I> line of code:<\/P>dtmTime = FormatDateTime(#11\/21\/2007 13:57#, vbShortTime)\n<\/PRE>\nThanks to the FormatDateTime<\/B> function, in this case dtmTime will be equal to 13:57; there won\u2019t be<\/I> a PM stuck at the end of the value. But that\u2019s OK, but our script doesn\u2019t rely on the AM\/PM designator. Instead, it just grabs the hour (13) and goes from there.<\/P>\n
Speaking of going somewhere, it\u2019s time to hit the road and get ready for another Turducken Bowl. Like we said, this year\u2019s game should be especially, uh, \u2026 interesting \u2026. <\/P>\n
Oh, well. Maybe the Scripting Guy who writes this column will get lucky and break his<\/I> leg before the game starts. But that\u2019s probably too much to hope for. See you all on Monday.<\/P>\n\n<\/THEAD>\n\n\n| \n Note<\/B>. In case you\u2019re wondering, the Turducken Bowl is named after the turducken, a legendary Thanksgiving dish made by stuffing a chicken inside a duck, stuffing the duck inside a turkey, then somehow cooking and eating the thing. Actually, we just assumed<\/I> that this was a legendary dish until last year, when we got email from a reader<\/B><\/A> who\u2019s actually eaten turducken. To the Scripting Guy who writes this column, having eaten a plate of turducken is on par with having eaten a plate of Bigfoot or Loch Ness Monster. <\/P>\nBy the way, if you have<\/I> eaten a plate of Bigfoot or Loch Ness Monster, drop us a line; we\u2019d love to hear about that<\/I><\/I>experience.<\/P>\n And for those of you outside the US, those of you still puzzling over the notion of stuffing a chicken inside a duck inside a turkey, the answer to your question is this: yes, only in America.<\/P><\/TD><\/TR><\/TBODY><\/TABLE><\/p>\n","protected":false},"excerpt":{"rendered":" Hey, Scripting Guy! Given a time of day, is there an easy way to tell whether that\u2019s a morning time or an evening time?— HG Hey, HG. Can you feel the excitement in the year, that sense of anticipation, the crackling energy and the flow of adrenalin? That can only mean one thing: the annual […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[13,31,3,5],"class_list":["post-63533","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-dates-and-times","tag-operating-system","tag-scripting-guy","tag-vbscript"],"acf":[],"blog_post_summary":" Hey, Scripting Guy! Given a time of day, is there an easy way to tell whether that\u2019s a morning time or an evening time?— HG Hey, HG. Can you feel the excitement in the year, that sense of anticipation, the crackling energy and the flow of adrenalin? That can only mean one thing: the annual […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/63533","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\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=63533"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/63533\/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=63533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=63533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=63533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} |
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
<\/H2>\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> \n