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():