My understanding on the below code is that this is adding one month to the current date. I need to add months to the date listed in a table.
Simon Slavin-3 wrote: > > > 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 > > -- View this message in context: http://old.nabble.com/Dates-based-on-fliter-tp30079627p30079831.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users