hi,
is it possible to get datetime diff betwen tables?
e.g.
db.define_table('check_in',
Field('is_booking', 'boolean'),
Field('booking', 'reference booking'),
Field('room', 'reference room'),
Field('guest', 'reference guest'),
Field('description', 'text'),
format='%(description)s')
db.define_table('check_out',
Field('check_in', 'reference check_in'),
Field('room', 'reference room'),
Field('guest', 'reference guest'),
Field('description', 'text'),
Field('duration', *compute=lambda r:
r['created_on']-r['check_in.created_on']*),
format='%(guest)s %(room)s')
when i test, it returns 0:00:00 in duration field.
any hints or suggestion to handle this?
thank you very much before
--
---
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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
