On 28 Oct 2010, at 7:58pm, Redhot wrote: > the first filter would be the Date entered to > Six months from the Date Entered. The Next would be Six months +1 to twelve > months from the date entered.
See http://www.sqlite.org/lang_datefunc.html and the example that says SELECT date('now','start of month','+1 month','-1 day'); Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users