{"id":69283,"date":"2005-07-29T11:37:00","date_gmt":"2005-07-29T11:37:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2005\/07\/29\/how-can-i-tell-if-a-date-falls-within-a-specified-time-period\/"},"modified":"2005-07-29T11:37:00","modified_gmt":"2005-07-29T11:37:00","slug":"how-can-i-tell-if-a-date-falls-within-a-specified-time-period","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-tell-if-a-date-falls-within-a-specified-time-period\/","title":{"rendered":"How Can I Tell if a Date Falls within a Specified Time Period?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! How can I tell if a date falls within a specified time period?

— JW<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

Hey, JW. By amazing coincidence on our way to work this morning we heard two different commercials, from two different companies, touting \u201cChristmas in July.\u201d That prompted us to answer your question as soon as we got to the office. After all, if these companies had a copy of the script you\u2019re looking for, then maybe they\u2019d know that Christmas doesn\u2019t<\/I> come in July.<\/P>\n\n<\/THEAD>\n\n\n
\n

Note<\/B>. Of course, we could be wrong about that, so maybe you should send all the Scripting Guys a present anyway, just to be on the safe side.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n

<\/DIV>\n

So how do we know that Christmas doesn\u2019t come in July? We simply ran the following script:<\/P>

dtmStartDate = #7\/1\/2005#\ndtmEndDate = #7\/31\/2005#\ndtmTargetDate = #12\/25\/2005#<\/p>\n
If dtmTargetDate >= dtmStartDate AND dtmTargetDate <= dtmEndDate Then\n    Wscript.Echo “The target date is within the specified range.”\nElse\n    Wscript.Echo “The target date is not within the specified range.”\nEnd If\n<\/PRE>\n
As you can see, we begin by assigning values to three variables. The variables dtmStartDate and dtmEndDate represent our date range; in this case, July 1, 2005 through July 31, 2005. The variable dtmTargetDate is the date in question: we want to know if this day (Christmas Day) comes in July.<\/P>\n
To do that, we need to know if the target date is greater than or equal to the start date and<\/I> if the target date is less than or equal to the end date. Here\u2019s the line of code that checks for that:<\/P>
If dtmTargetDate >= dtmStartDate AND dtmTargetDate <= dtmEndDate Then\n<\/PRE>\n
In order to be true a date must meet both conditions. December 25, 2005 is greater than or equal to the start date of July 1, 2005, so our target date meets condition 1. However, December 25, 2005 is not<\/I> less than or equal to July 31, 2005. The target date fails condition 2, which means that the statement is not true. (Remember, both<\/I> conditions must be true.) As a result, we know that Christmas doesn\u2019t<\/I> come in July, and we echo a message to that effect. Had both conditions been true, we would have echoed the jolly holiday message, \u201cThe target date is within the specified range.\u201d<\/P>\n
Hope that helps, JW. Merry Christmas to all and to all a good night.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I tell if a date falls within a specified time period?— JW Hey, JW. By amazing coincidence on our way to work this morning we heard two different commercials, from two different companies, touting \u201cChristmas in July.\u201d That prompted us to answer your question as soon as we got to […]<\/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,3,4,5],"class_list":["post-69283","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-dates-and-times","tag-scripting-guy","tag-scripting-techniques","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I tell if a date falls within a specified time period?— JW Hey, JW. By amazing coincidence on our way to work this morning we heard two different commercials, from two different companies, touting \u201cChristmas in July.\u201d That prompted us to answer your question as soon as we got to […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/69283","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=69283"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/69283\/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=69283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=69283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=69283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}