Finding data between a period-Linq to XML

 
var xelement = XElement.Parse(@"
	
	
 
	2007-01-01
	2007-12-31
 


 
	Member
 
 
	2007-01-01
	2007-12-31
 


 
	2006-01-01
	2006-12-31
 

01234
04556
427000000
427000000
23450
45890
");

var contextIds = from st in xelement.Elements("SampleTag")
				 join ct in
			( xelement
	.Elements("contet")
	.Elements("period")
	.Where (e => DateTime.Parse(e.Element("startDate").Value) >= new DateTime(2006,12,01) && 
	DateTime.Parse(e.Element("endDate").Value) <= new DateTime(2008,12,31))
	.Select (e => e.Parent.Attribute("id").Value)) on st.Attribute("contetRef").Value equals ct
	select st.Value;