public void CountPointsInRange()
{
MonthDayRange range = new MonthDayRange(1, 1, 2, 29);
DateRange dr = new DateRange(range, 2000, 1);
Assert.AreEqual(dr.Count, 60);
dr = new DateRange(range, 2001, 1);
Assert.AreEqual(dr.Count, 59);
}
public static Series Subset(Series s, DateRange dateRange, bool includeEndDateTimes=true)
{
string dateColumnName = s.Table.Columns[0].ColumnName;
Series rval = s.Clone();
var sql = "";
if (includeEndDateTimes)
{
sql = "[" + dateColumnName + "] >= '" + dateRange.DateTime1 + "'"
+ " and "
+ "[" + dateColumnName + "] <= '" + dateRange.DateTime2 + "'"
+ " ";
}
else
{
sql = "[" + dateColumnName + "] >= '" + dateRange.DateTime1 + "'"
+ " and "
+ "[" + dateColumnName + "] < '" + dateRange.DateTime2 + "'"
+ " ";
}
rval = s.Subset(sql);
return rval;
}
