On November 10, 2008 09:27:18 am Rolf Leggewie wrote: > Hi, > > I have entered a transaction for July 1st. This is what it looks like > in the XML file. > > <trn:date-posted> > <ts:date>2008-07-01 00:00:00 +0200</ts:date> > </trn:date-posted> > > When I save that in the SQL backend, it becomes 20080630220000. Now > when I run a quarterly report on the SQL database, that transaction is > counted for the second quarter when it should have been counted in the > third. > > Anybody have an idea how things turned out the way they did?
Dates are stored as UTC in the SQL backend and converted back to local time when the records are retrieved. Date format is YYYYMMDDHHMMSS. Seemed cleanest to me at the time, but there's been a long discussion on this mailing list about dates/times. Phil _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
