Hi, Many thanks. Tried it and it didn't work. I had a rather subtle error in my code it seems... and then it worked just fine.
Sometimes just changing some code rather than staring at it triggers a chain of failure and thinking events and the solution emerges! Thanks for the tip - much appreciated. Paul. On Oct 12, 11:07 am, annet <[email protected]> wrote: > Hi Paul, > > I faced a similar problem and worked out the following solution: > > db.define_tables("publications", > Field('publish','date',default=request.now,notnull=True), > Field('expire','date',default=request.now > +datetime.timedelta(days=28),notnull=True), > Field(...)) > > rows=db((db.publications.publish<=request.now)&(db.publications.expire>requ > est.now)).select() > > I hopes this points you in the right direction to solve your problem. > > Kind regards, > > Annet.
