I belive the and operator is not used with query expressions. I think the proper intersection is query1 & query2... & queryN
On 29 ene, 15:22, Sanjeet roy <[email protected]> wrote: > I have one date column due_date here i want to select the all data > between dates one is starting date and one is end date both are taken > manually so if the user select cmnpny and start and end date all the > data related to company between choosen date should be come > my code is below but i don't able to get the proper data: > for row in db(db.f_company_compliance.company == session.company and > db.f_company_compliance.due_date >= session.strtdate and > db.f_company_compliance.due_date <= session.enddate).select():
