[GNC] Date error running report from gnucash-cli, report runs fine in GUI

[Geoff]

Well, in that case it should work out of the box like this:

C:\BUDGET>"C:\Program Files (x86)\gnucash\bin\gnucash-cli" -R run --name 
"68827f48ea584054a227fbf7591a2b1b" --output-file "C:\Temp\BS.html" 
mybudget.gnucash

NOTE that in this case, because I have multiple Balance Sheet reports, 
I had to specify the report name using its GUID as I encountered an 
error when I used: -R run --name "Balance Sheet", however the error 
message kindly gave me the GUID.

Hope this helps.

Regards

Geoff
=====

On 21/09/2022 8:48 pm, William Starrs wrote:
> Hello Jeff, I am au courant with Python (le Python c'est bon!)  Thank 
> you for that suggestion, I will give it a try.
> 
> To be clear, all of the date filtering combinations that I tried were 
> part of the saved report configurations, I was not trying to provide any 
> parameters via command line other than to run the saved report as-is.
> 
> Bill
> 
> On Wed, Sep 21, 2022 at 5:36 AM Geoff <cleanoutmyshed at gmail.com 
> <mailto:cleanoutmyshed at gmail.com>> wrote:
> 
>     Hi William
> 
>     Based on my interpretation of the gnucash-cli --help text, and this
>     Reddit forum post, I don't think that it is possible to pass date
>     parameters to reports from the command line.
> 
>     https://www.reddit.com/r/GnuCash/comments/mf834b/how_to_use_gnucashcliexe_on_windows_to_run_a/
>     <https://www.reddit.com/r/GnuCash/comments/mf834b/how_to_use_gnucashcliexe_on_windows_to_run_a/>
> 
>     If you are au courant with Python you could probably achieve a
>     transaction list for a custom date range fairly easily using PieCash:
> 
>     https://github.com/sdementen/piecash
>     <https://github.com/sdementen/piecash>
> 
>     Good luck!
> 
>     Regards
> 
>     Geoff
>     =====
> 
>     On 21/09/2022 9:38 am, William Starrs wrote:
>      > Update:  I tried also setting a fixed Start Date and end of
>     "Today", as
>      > well as a fixed start and end date.  All configurations give the same
>      > error.  Again, no error in the GUI.
>      >
>      > Thanks,
>      >
>      > Bill
>      >
>      > On Mon, Sep 19, 2022 at 3:27 PM William Starrs
>     <wjstarrsiii at gmail.com <mailto:wjstarrsiii at gmail.com>>
>      > wrote:
>      >
>      >> Hello,
>      >>
>      >> I would like to script a report that will show me all
>     transactions on
>      >> credit cards since their last closing date.  I'll maintain
>     closing dates
>      >> outside of Gnucash.  I have the report set to show me all
>     transactions
>      >> since the start of the previous quarter (so it is rolling)
>     through today.
>      >> I would then filter out transactions prior to the closing date in
>      >> post-processing.
>      >>
>      >> The report runs fine in the GUI, but when I try to run from
>     gnucash-cli I
>      >> get the following error:
>      >>
>      >>      ERROR <gnc.engine.sx <http://gnc.engine.sx>> Bad End Date:
>     Invalid or before Start Date
>      >>
>      >> The -R show command shows options regarding the dates that ought
>     to work:
>      >>
>      >> General / Start Date: relative . start-prev-quarter
>      >> General / End Date: relative . today
>      >>
>      >> So I can't think of a situation where the start of previous
>     quarter would
>      >> be missing or before today.
>      >>
>      >> Any suggestions?
>      >>
>      >> Thanks
>      >>
>      >> Bill
>      >>
>      > _______________________________________________
>      > gnucash-user mailing list
>      > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>      > To update your subscription preferences or to unsubscribe:
>      > https://lists.gnucash.org/mailman/listinfo/gnucash-user
>     <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>      > -----
>      > Please remember to CC this list on all your replies.
>      > You can do this by using Reply-To-List or Reply-All.
>