Request.RootDir = "../calendar"; Request.PageTitle = "Calendar"; // Search Start SearchStart = CreateDateTime(URL.Year, URL.Month, URL.Day, ListFirst(Request.App.CalendarStartTime, ":"), ListLast(Request.App.CalendarStartTime, ":"), 0); // Search End SearchEnd = CreateDateTime(URL.Year, URL.Month, URL.Day, ListFirst(Request.App.CalendarEndTime, ":"), ListLast(Request.App.CalendarEndTime, ":"), 59); SELECT e.EventID, e.EventName, e.StartDateTime, e.EndDateTime, e.EventShortDesc, e.active, e.Location, t.EventType FROM cal_event e INNER JOIN cal_event_type t ON e.EventTypeID = t.EventTypeID WHERE active = 1 AND e.StartDateTime <= #SearchEnd# AND e.EndDateTime >= #SearchStart# ORDER BY e.StartDateTime

:: :: #MonthAsString(url.Month)# #url.Day#, #url.Year#

Summary of #DateFormat(SearchStart, "mmmm dd, yyyy")# Events
Sorry, but there are no events for this day in our system.
#MonthAsString(Month(StartDateTime))# #DateFormat(StartDateTime, "D")# - #MonthAsString(Month(EndDateTime))# #DateFormat(EndDateTime, "D")# #EventType#	#EventName# #Location#, #TimeFormat(StartDateTime)# - #TimeFormat(EndDateTime)#
	#EventShortDesc#

Summary of #DateFormat(SearchStart, "mmmm dd, yyyy")# Events