I just found out that gnucash stores DatePosted and DateEntered as Strings instead of the proper DateTime or Timestamp sql data-types.
Why is that? In XML it already uses a proper date-format. This makes is very hard to sort by date in SQL-queries and to select a range as you need a complex fulltext-index instead of a trivial integer index. (There are supposed to be MANY transactions and splits in there.) Marcus _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
