Re: [sqlite] Sorting by month with two dates input

>>I have to create some reporting and I need to report on customers amount1 >>and amount2 two based on the whole year of 2013. There are two dates that >>are to be used as input: billdate and bdate. I can do one or the other, >>but, I can not seem to get the correct date when using both. The

Re: [sqlite] Sorting by month with two dates input

On 2014-08-31, 9:35 PM, Darren Duncan wrote: On 2014-08-31, 9:10 PM, jose isaias cabrera wrote: SELECT cust, sum(ProjFund), sum(Xtra8), coalesce(billdate,bdate) as t FROM LSOpenProjects WHERE billdate BETWEEN '2013-01-01' AND '2013-12-31' OR bdate BETWEEN '2013-01-01' AND '2013-12-31' GROUP BY

Re: [sqlite] Sorting by month with two dates input

On 2014-08-31, 9:10 PM, jose isaias cabrera wrote: SELECT cust, sum(ProjFund), sum(Xtra8), coalesce(billdate,bdate) as t FROM LSOpenProjects WHERE billdate BETWEEN '2013-01-01' AND '2013-12-31' OR bdate BETWEEN '2013-01-01' AND '2013-12-31' GROUP BY substr(t,1,7), cust; I'm surprised that even

[sqlite] Sorting by month with two dates input

Greetings! I have to create some reporting and I need to report on customers amount1 and amount2 two based on the whole year of 2013. There are two dates that are to be used as input: billdate and bdate. I can do one or the other, but, I can not seem to get the correct date when using both.

Re: [sqlite] SQLite Database Browser v3.3.0 released

On Sun, Aug 31, 2014 at 11:49 AM, wrote: > On 2014-08-27 23:02, Richard Hipp wrote: > >> On Wed, Aug 27, 2014 at 6:18 PM, wrote: >> >>> >>> This is in process now: >>> >>> https://github.com/sqlitebrowser/sqlitebrowser/pull/83 >>> >>> Might need a

Re: [sqlite] SQLite Database Browser v3.3.0 released

On 2014-08-27 23:02, Richard Hipp wrote: On Wed, Aug 27, 2014 at 6:18 PM, wrote: This is in process now: https://github.com/sqlitebrowser/sqlitebrowser/pull/83 Might need a few code extra code tweaks (unsure), but we'll get it done and push out an updated release