Rick Ratchford wrote: > #>Try > #> > #>date(max(Date), 'weekday 5') > > It's likely I'm not using it correctly, because it returns nothing. :(
I mean, replace "Date" in your statement with this expression. As in SELECT date(max(Date), 'weekday 5') FROM MyTable GROUP BY Year, Week; > #>> Is there an answer to my problem somewhere in the above output? > #> > #>No, not directly. Teach a man to fish, and all that. > > Completely understand. Just wish my fishing pole was a little more > forgiving. :) An interesting specimen of a double entendre here. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
