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 ('{40D5EC84-EF0C-4602-BC97-68B633019F38}')) AND cd.ChannelID = c.ChannelID AND cd.Status IN (1) AND (GetDate() BETWEEN IsNull(PublishStart,GetDate()) AND IsNull(PublishStop,GetDate()+1)) AND DATEPART(month,StartDateTime) = DATEPART(month,'5/7/2012') AND DATEPART(year,StartDateTime) = DATEPART(year,'5/7/2012') AND DATEPART(year,StartDateTime) = DATEPART(year,'5/7/2012') ORDER BY StartDateTime ASC There are no calendar items for 5/7/2012.
| 
2013 Claremont Graduate University 
150 E. 10th St., Claremont, CA 91711 