DBCS Calendar

ERROR!
#banner_text#
#menutext#
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
 
bgcolor='#c6eff7' >#i#
select RecordID, StartDate, EndDate, StartTime, EndTime, Title, Location, 0 as team_id, '' as Opponent1, '' as Opponent2, '' as gender from Calendar where StartDate <= ###DateFormat(this_day, application.GSHORTDTFRM)### and EndDate >= ###DateFormat(this_day, application.GSHORTDTFRM)### UNION select RecordID, StartDate, EndDate, StartTime, '', team_level+' '+team_name as Title, Location, TeamGames.team_id, Opponent1, Opponent2, gender from TeamGames, Teams where TeamGames.team_id = Teams.team_id and ((Opponent1 = 'DBCS') or (Opponent2 = 'DBCS')) and ((game_status = #REGULARGAME#) or (game_status = #TOURNGAME#)) and StartDate <= ###DateFormat(this_day, application.GSHORTDTFRM)### and EndDate >= ###DateFormat(this_day, application.GSHORTDTFRM)### order by StartTime #TimeFormat(StartTime, application.GLONGTMFRM)# #Left(qryEvents.Title, 20)#
#qryEvents.Title# @" & qryEvents.Location> #whowhere#
 
Previous Month Current Month Next Month
 
Have an event that should be on the calendar? Submit it here.

|  #MonthAsString(show_month)# |