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; }