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
...@sqlite.org on behalf of Redhot
Sent: Thu 10/28/2010 1:58 PM
To: sqlite-users@sqlite.org
Subject: EXTERNAL:[sqlite] Dates based on fliter
I would like to add the 6 months, 12 months 18 months and 24 months to a
date entered into the sqlite database. The date in the database is in sql
form
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
I would like to add the 6 months, 12 months 18 months and 24 months to a
date entered into the sqlite database. The date in the database is in sql
formate -MM-DD. The dates will be used for a filter. The filter will
pull Rows from a table. Like the first filter would be the Date entered to
4 matches
Mail list logo