[GNC] How can I make GnuCash store all dates in only 1 format?

Mark Debian mark_debian at yahoo.com
Tue Jul 30 09:10:46 EDT 2019


 Thanks for the explanation.
I just did a "save as" and now my dates are all in the new format.  Much easier to work with just one format for the dates.  Also the new format is recognised by the sqlite3 date function whereas the old format was not.

Thanks.

    On Tuesday, 30 July 2019, 7:29:47 am AEST, John Ralls <jralls at ceridwen.us> wrote:  
 
 

> On Jul 29, 2019, at 7:50 AM, Derek Atkins <derek at ihtfp.com> wrote:
> 
> John,
> 
> On Mon, July 29, 2019 10:35 am, John Ralls wrote:
> [snip]
>> The simplest way to get all date-times in the new format is to just save
>> your book to XML then open that and save it back to SQLite3.
> 
> Do you even have to do this?  Couldn't you just File -> Save As and choose
> a (new) SQLite file to have it re-write a new file in the new format?  Why
> would you need to go to XML and back?

Derek,

You're right, a single save-as would work just as well.

Regards,
John Ralls

  


More information about the gnucash-user mailing list