Should work but I do not see a checkout.created_on field.
On Wednesday, 27 March 2013 21:16:25 UTC-5, 黄祥 wrote:
>
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
