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
Sorry, that should have read:
When I look at the transactions table I have dates in the following formats:
1: mmddHHMMSS
2: -mm-dd HH:MM:SS
Unfortunately, the sqlite date, datetime, strftime functions will not recognise
the first format as a date.
_
I have a script I use to massage data from GnuCash via the sqlite backend.
It looks like the format that dates are stored in the database backend has
changed over time and this is causing me problems. When I look at the
transactions table I have dates in the following
formats:mmddHHMMSSYYY
