SAH Events Calendar

S
M
T
W
T
F
S
29
30
31
1
Select a Calendar
SOR | Events
SAH | Events
sql: select ItemID,Title,SourceURL,SourceURLPopWin,null as SubTitle,null as TeaserText,RelatedURL,RelatedURLPopWin,c.DetailURL, Subtitle,StartDateTime,StopDateTime,cd.ChannelID FROM ChannelData cd, Channel c WHERE (cd.ChannelID IN ('{7CC1B192-5F50-402B-AB3C-FAB2B17A44B9}','{3E333D64-EF79-45B2-8532-98BC17021BEB}')) AND cd.ChannelID = c.ChannelID AND cd.Status IN (1) AND (GetDate() BETWEEN IsNull(PublishStart,GetDate()) AND IsNull(PublishStop,GetDate()+1)) AND (('8/1/2012' BETWEEN Cast(Left(StartDateTime,11) AS DateTime) AND IsNull(StopDateTime,DateAdd(day,1,StartDateTime))) OR (Cast(Left(StartDateTime,11) AS DateTime) = '8/1/2012')) AND DATEPART(month,StartDateTime) = DATEPART(month,'8/1/2012') AND DATEPART(year,StartDateTime) = DATEPART(year,'8/1/2012') ORDER BY StartDateTime ASC,cd.ChannelID,ListPosition,Title

There are no calendar items for 8/1/2012.

 

2014 Claremont Graduate University 150 E. 10th St., Claremont, CA 91711 (909) 621-8000 Campus Safety Emergency Info Campus Map/Driving Directions