{"id":85929,"date":"2004-08-27T12:04:29","date_gmt":"2004-08-27T20:04:29","guid":{"rendered":"http:\/\/devblogs.microsoft.com\/scripting\/?p=85929"},"modified":"2019-06-03T12:34:08","modified_gmt":"2019-06-03T20:34:08","slug":"how-can-i-determine-the-day-of-the-week","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-determine-the-day-of-the-week\/","title":{"rendered":"How Can I Determine the Day of the Week?"},"content":{"rendered":"

\"question\"<\/p>\n

Hey, Scripting Guy! I have a script that does certain management tasks based on the day of the week. I know how get the date in a script, but how can I tell whether it\u2019s a Monday or a Tuesday or whatever?<\/p>\n

— CT, Tallahassee, FL<\/p>\n

\"\"<\/p>\n

\"answer\"\n\"\"<\/p>\n

<\/p>\n

Hey, CT. This is actually much easier then it might sound; that\u2019s because VBScript has a built-in function called DatePart that can take any date you give it and tell you everything from the hour to the minute to the day of the week. All you have to do is pass DatePart two items:<\/p>\n\n<\/thead>\n\n\n\n
\n

The date part you\u2019re looking for.<\/b><\/p>\n<\/td>\n

\n

In this case, we\u2019re looking for the day of the week, so we pass the value \u201cw\u201d. If we were looking for, say, the year, we\u2019d pass the value \u201cy\u201d.<\/p>\n<\/td>\n<\/tr>\n

\n

The date in question.<\/b><\/p>\n<\/td>\n

\n

For this script, we simply assign the current date to the variable dtmToday.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/div>\n

Our script ends up looking something like this:<\/p>\n

dtmToday = Date()\r\n\r\ndtmDayOfWeek = DatePart(\"w\", dtmToday)\r\n\r\nSelect Case dtmDayOfWeek\r\n    Case 1 Wscript.Echo \"Sunday\"\r\n    Case 2 Wscript.Echo \"Monday\"\r\n    Case 3 Wscript.Echo \"Tuesday\"\r\n    Case 4 Wscript.Echo \"Wednesday\"\r\n    Case 5 Wscript.Echo \"Thursday\"\r\n    Case 6 Wscript.Echo \"Friday\"\r\n    Case 7 Wscript.Echo \"Saturday\"\r\nEnd Select\r\n<\/pre>\n
Note the one tricky part: the day of the week comes back as an integer (1 = Sunday, 2 = Monday, etc.). Therefore, for the purposes of this<\/i> script we used a Select Case statement to convert that integer into the actual day of the week itself.<\/p>\n
For more information about the DatePart function, see this portion of the Microsoft Windows 2000 Scripting Guide<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! I have a script that does certain management tasks based on the day of the week. I know how get the date in a script, but how can I tell whether it\u2019s a Monday or a Tuesday or whatever? — CT, Tallahassee, FL Hey, CT. This is actually much easier then it […]<\/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":[162,56,597,650,3,45],"class_list":["post-85929","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-boe-prox","tag-guest-blogger","tag-module","tag-runspace","tag-scripting-guy","tag-windows-powershell"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! I have a script that does certain management tasks based on the day of the week. I know how get the date in a script, but how can I tell whether it\u2019s a Monday or a Tuesday or whatever? — CT, Tallahassee, FL Hey, CT. This is actually much easier then it […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/85929","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=85929"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/85929\/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=85929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=85929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=85929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}