{"id":68193,"date":"2006-01-12T12:59:00","date_gmt":"2006-01-12T12:59:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2006\/01\/12\/how-can-i-determine-which-day-of-the-year-a-date-falls-on\/"},"modified":"2006-01-12T12:59:00","modified_gmt":"2006-01-12T12:59:00","slug":"how-can-i-determine-which-day-of-the-year-a-date-falls-on","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-determine-which-day-of-the-year-a-date-falls-on\/","title":{"rendered":"How Can I Determine Which Day of the Year a Date Falls On?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! How can I determine which day of the year a date falls on? For example, March 2, 2006 is the 61st<\/SUP> day of the year.

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

Hey, TW. You know, we almost feel guilty about answering this question. Why? Well, after all, we can answer it by writing just one line of code:<\/P>

Wscript.Echo DatePart(“y”, “3\/2\/2006”)\n<\/PRE>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. So if it\u2019s that easy why do we almost<\/I> feel guilty about answering the question; why don\u2019t we actually feel<\/I> guilty? Well, to be honest, we believe the Scripting Guys deserve a break once in awhile. After all, look at a typical Scripting Guys day: we might have to write a Scripting Week song or put together a crossword puzzle; for that matter, we might be forced to play around with Microsoft Agent or Windows Media Player. This is obviously arduous and back-breaking work, and yet we do it day in and day out. (Well, except for the extended vacation time we all just finished taking.) You see what we have to go through on a daily basis; surely you can cut us some slack every now and then?<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
As far as determining the day of the year for a particular date, well, needless to say that doesn\u2019t require much effort: we simply call the DatePart<\/B> function and pass it two parameters:<\/P>\n\n\n\n\n
\u2022<\/TD>\n\n
\u201cy\u201d<\/B>, which tells DatePart that we want to know the day of the year.<\/P><\/TD><\/TR>\n
\u2022<\/TD>\n\n
\u201c3\/2\/2006\u201d<\/B>, which tells DatePart which date we need information for.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
That\u2019s all we have to do. In turn, DatePart calculates the day of the year and the script echoes the value – 61 – back to us.<\/P>\n
What\u2019s cool about DatePart is that it can retrieve other date-related information besides day of the year. For example, want to know the week<\/I> of the year that 3\/2\/2006 falls in? Here you go:<\/P>
Wscript.Echo DatePart(“ww”, “3\/2\/2006”)\n<\/PRE>\n
In this case DatePart returns a 9, meaning that 3\/2\/2006 falls in the ninth week of 2006. How about the quarter:<\/P>
Wscript.Echo DatePart(“q”, “3\/2\/2006”)\n<\/PRE>\n
Did someone ask what day of the week 3\/2\/2006 falls on? Here\u2019s a script that can help you with that:<\/P>
intDay = DatePart(“w”, “3\/2\/2006”)<\/p>\n
Select Case intDay\n    Case 1\n        Wscript.Echo “Sunday”\n    Case 2\n        Wscript.Echo “Monday”\n    Case 3\n        Wscript.Echo “Tuesday”\n    Case 4\n        Wscript.Echo “Wednesday”\n    Case 5\n        Wscript.Echo “Thursday”\n    Case 6\n        Wscript.Echo “Friday”\n    Case 7\n        Wscript.Echo “Saturday”\nEnd Select\n<\/PRE>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. If you can\u2019t stand the suspense any longer, 3\/2\/2006 falls on a Thursday.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
Here\u2019s a complete list of all the different date parts that DatePart can return:<\/P>\n\n<\/THEAD>\n\n\n\n\n\n\n\n\n\n\n\n\n
\n
Setting<\/B><\/P><\/TD>\n
\n
Description<\/B><\/P><\/TD><\/TR>\n
\n
yyyy<\/P><\/TD>\n
\n
Year<\/P><\/TD><\/TR>\n
\n
q<\/P><\/TD>\n
\n
Quarter<\/P><\/TD><\/TR>\n
\n
m<\/P><\/TD>\n
\n
Month<\/P><\/TD><\/TR>\n
\n
y<\/P><\/TD>\n
\n
Day of the year<\/P><\/TD><\/TR>\n
\n
d<\/P><\/TD>\n
\n
Day<\/P><\/TD><\/TR>\n
\n
w<\/P><\/TD>\n
\n
Day of the week<\/P><\/TD><\/TR>\n
\n
ww<\/P><\/TD>\n
\n
Week of the year<\/P><\/TD><\/TR>\n
\n
h<\/P><\/TD>\n
\n
Hour<\/P><\/TD><\/TR>\n
\n
n<\/P><\/TD>\n
\n
Minute<\/P><\/TD><\/TR>\n
\n
s<\/P><\/TD>\n
\n
Second<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
And now, if you\u2019ll excuse us, we have another grueling day to try and get through. Should we have filet mignon again<\/I> at lunch, or should we try something new today? It\u2019s a tough job, but someone has to do it.<\/P>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. Please don\u2019t point out to our managers that no one has<\/I> to do this. Thanks!<\/P><\/TD><\/TR><\/TBODY><\/TABLE><\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I determine which day of the year a date falls on? For example, March 2, 2006 is the 61st day of the year.— TW Hey, TW. You know, we almost feel guilty about answering this question. Why? Well, after all, we can answer it by writing just one line of […]<\/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-68193","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 determine which day of the year a date falls on? For example, March 2, 2006 is the 61st day of the year.— TW Hey, TW. You know, we almost feel guilty about answering this question. Why? Well, after all, we can answer it by writing just one line of […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/68193","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=68193"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/68193\/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=68193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=68193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=68193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}