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.


Reply via email to