On 4/08/2009 8:52 AM, Rick Ratchford wrote: > > What I want to do is modify this SELECT statement so that the rows returned > do not go past a certain date. Let's call it dStopDate. > > If I have dStopDate = '2009-28-07'
Did you mean '2009-07-28' ? > for example, then the last row I want to > return is 07/24/2009, which is the last week prior to my dStopDate. > > However, by adding WHERE Date < '" dStopDate "' prior to GROUP BY... (and > yes, assume Date and dStopDate are same format), my last record returned is > actually 07/27/2009 (the day before my dStopDate) rather than my 'weekly' > record of 07/24/2009. Did you mean "<=" instead of "<" ? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
