it seems can't handle compute for datetime diff between tables in database side, i've found the clue on controller side : *db.py* db.define_table('check_out', Field('check_in', 'reference check_in'), Field('room', 'reference room'), Field('guest', 'reference guest'), Field('description', 'text'), * Field('duration'),* format='%(guest)s %(room)s')
*default.py* def __onvalidation_check_out(form): if form.vars.check_in: rows = db(db.check_in.id==form.vars.check_in).select() for row in rows: form.vars.room = row.room form.vars.guest = row.guest * form.vars.duration = request.now - row.created_on* else: form.errors.check_in = 'cannot be empty' def check_out(): query = db.check_out.is_active==True grid=SQLFORM.grid(query, user_signature=False, onvalidation=__onvalidation_check_out) return locals() *output result for duration :* 0:00:11.680686 7 days, 0:01:19.547619 best regards -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.