I've already built it from the scratch (new data, new application) for all your recommendation function above. The data for created on is set by default in function signature in db.py. I can share the full apps, if you want.
Any recommendation how to solve this? Thank you very much Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT -----Original Message----- From: Massimo Di Pierro <[email protected]> Sender: [email protected] Date: Sun, 31 Mar 2013 18:41:17 To: <[email protected]> Reply-To: [email protected] Subject: [web2py] Re: datetime diff between tables I do not think there is a problem with the function. I think there is a problem with the data. On Sunday, 31 March 2013 20:38:06 UTC-5, 黄祥 wrote: > > 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. -- --- 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.
