[web2py] Displaying data of same date from two tables

Hi, I want to create some small accounting program and am having some issue with creating a proper balance view. I have 2 tables, one for incomes and one for expenditures, each with the corresponding money and the date of data entry: db.incomes.income_USD db.incomes.calendar_date db.expenditur

[web2py] Re: Database error: month must be in 1..12

Thank you Dave, that fixed it for me, so that I can access the page again. The table is defined like that: db.define_table('income', Field('description','string',label='Description *', requires=IS_NOT_EMPTY()), Field('category','reference inc_categories',la

[web2py] Database error: month must be in 1..12

Hello, I can't access my web2py page anymore, as it is showing the following error: month must be in 1..12 Variables datetime.date val '2016-14-12' global datetime builtinint val.split builtinmap I am using SQLite. I can't access the database from the admin frontend either, as a query t