MMEX Discussion Forum

Posted: **Sat Nov 08, 2014 3:53 pm**

: gifts_sample.png (15.17 KiB) Viewed 7604 times

-------------------------------------------

Posted: **Sun Nov 09, 2014 12:35 pm**

Updated report with currency formating and difference between deposits and withdrawals and columns sorting.

Posted: **Wed Apr 01, 2015 1:08 pm**

Hello Nikolay.
Your reports are very useful. Thanks a lot.
But, in my situation, today for example (April, 1st), I would like to view all April, 2014 deposits and expenses from account that I chose, and the report show me only April 30th 2014, deposits and expenses.

How change it?

Thank you.

Daniel

Posted: **Wed Apr 01, 2015 1:46 pm**

Hi Daniel,

Try to change SQL line 14

Code: Select all

where (date('now', 'start of month','-11 month','localtime') <= c.transdate

to

Code: Select all

where (date('now', 'start of month','-12 month','localtime') <= c.transdate

Posted: **Wed Apr 01, 2015 2:02 pm**

Thanks for your reply Nikolay.

I made the change, but the report shows me March, 31th 2014 now. And how I didn't do any deposit or expense on that day, the report shows me $0.00

It helped a little, but is possible don't show March? Just the interval of completed 12 Months?

Thank you again. And sorry the hassle.

Daniel

Posted: **Wed Apr 01, 2015 8:28 pm**

Changes are correct. I can't reproduce bug with 31-march-2014.

Posted: **Fri Feb 02, 2018 9:07 am**

Hiiii

Your report is really nice. Thank for suggestion.......

Posted: **Sat Feb 03, 2018 1:51 pm**

shawn1254 wrote:Hiiii

Your report is really nice. Thank for suggestion.......

Nice to hear it.

MMEX Discussion Forum

My Gifts

My Gifts

Re: My Gifts

Re: My Gifts

Re: My Gifts

Re: My Gifts

Re: My Gifts

Re: My Gifts

Re: My Gifts