Maybe something like:
CREATE VIEW "Sum of Expenses Between two Dates" AS
SELECT Date,
sum( CASE
WHEN Date BETWEEN date('now', '-1 months') AND date('2019-11-04',
'-1 days') THEN Expense
ELSE 0
END) as 'Sum of Expenses:'
FROM Expenses;
On 11/15/2019 12:22 PM, David Raymond wrote:
> So why do you need a case? What will not work with the simple:
>
> select sum(Expense)
> from Expenses
> where Date between date('now', '-1 months') and date('2019-11-04', '-1 days');
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
