with tdiff function have same result it's give 0.00 as the result.

yes, i've tried the difference both (more than 1 day and in the same day) 
but all of it return 0 when i set duration is integer, 0:00:00 when i set 
duration in datetime and 0.00 when i set duration in double.

when i try it with 1 table the compute can work with datetime format for 
both of different time (more than 1 day and in the same day).
e.g.
db.define_table('activity',
    Field('subject'),
    Field('activity_type', 'list:string'),
    Field('contact', 'reference contact'),
    Field('description', 'text'),
    Field('scheduled_start', 'datetime'),
    Field('due_date', 'datetime'),
    Field('actual_start', 'datetime'),
    Field('actual_end', 'datetime'),
*    Field('duration', compute=lambda r: r['actual_end']-r['actual_start']),
*
    Field('priority', 'list:string'),
    Field('status', 'list:string'),
    auth.signature)

have another solution for handle this thing?
thanks a lot 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.


Reply via email to