SQL Calendar

<%@ LANGUAGE=VBScript %> <% wYear=Request.QueryString("wYear") IF wYear = "" THEN wYear=Request.Form("wYear") IF wYear = "" OR wYear < 1753 OR wYear > 9999 THEN wYear = DATEPART("yyyy",now()) %> SQL Calendar

<%=wYear%> Calendar

<% mc = 0 FOR mc = 1 TO 12 %> <% 'Determine day of the week the month begins on tempdate = mc & "/1/" & wYear bwdom = datepart("w", tempdate) DayOfWeekCounter = 0 'This "week" has 8 "days" to include the Name of the Month column. 'PRINT LEADING BLANK DAYS SELECT CASE bwdom CASE 1 DayOfWeekCounter = 1 CASE 2 %> <%DayOfWeekCounter = 2 CASE 3 %> <%DayOfWeekCounter = 3 CASE 4 %> <%DayOfWeekCounter = 4 CASE 5 %> <%DayOfWeekCounter = 5 CASE 6 %> <%DayOfWeekCounter = 6 CASE 7 %> <%DayOfWeekCounter = 7 CASE ELSE %> <% END SELECT 'Determine last day of month & number of weeks IF mc < 12 THEN ldom = Day(DateAdd("d", -1, mc + 1 & "/1/" & wYear)) ELSE ldom = Day(DateAdd("d", -1, "1/1/" & wYear + 1)) END IF NumWeeks = 5 IF (bwdom = 6 AND ldom = 31) OR (bwdom = 7 AND ldom > 29) THEN NumWeeks = 6 DayCounter = 1 WeekCounter = 1 DO WHILE WeekCounter < NumWeeks + 1 DO WHILE DayOfWeekCounter < 8 IF DayCounter < ldom + 1 THEN %> <% 'IF statements for holidays and anniversaries goes here. %> <%ELSE%> <%END IF DayOfWeekCounter = DayOfWeekCounter + 1 DayCounter = DayCounter + 1 LOOP DayOfWeekCounter = 1 WeekCounter = WeekCounter + 1 %> <%LOOP%> <%NEXT%>

Sun.

Mon.

Tue.

Wed.

Thu.

Fri.

Sat.

<%=MonthName(mc)%>

Beginning Day of Week Error

<%=DayCounter%>

file: /techref/language/asp/calendar/stdcal.asp.txt, 2KB, , updated: 1999/3/2 20:05, local time: 2008/7/5 08:58,

^{38.103.63.16:LOG IN}

©2008 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions?
Please DO link to this page! Digg it!
<A HREF="http://www.piclist.com/techref/language/asp/calendar/stdcal.asp.txt"> SQL Calendar</A>

Did you find what you needed?

PICList 2008 contributors:
o List host: MIT, Site host massmind.org, Top posters @20080705 Apptech, Jinx, Xiaofan Chen, Alan B. Pearce, David VanHorn, Bob Axtell, William \Chops\ Westfield, Cedric Chang, olin piclist, Gerhard Fiedler,
* Page Editors: James Newton, David Cary, and YOU!
* Roman Black of Black Robotics donates from sales of Linistep stepper controller kits.
* Ashley Roll of Digital Nemesis donates from sales of RCL-1 RS232 to TTL converters.
* Monthly Subscribers: Shultz Electronics, Larry Williams, David VanHorn, Bryan Whitehouse, Timothy Weber, David Challis. Peter Todd. on-going support is MOST appreciated!
* Contributors: Neil Narwani, David Cary, Elemer AM Nyiry, Philip J Taylor, Gus Calabrese of Omegadogs.com, Gautama Venegas, Patrick B. Murphy, William Chops Westfield, Peter Todd, Leslie Ellis