It works SP, thank you.
Regards:
Mostwanted
On Thursday, October 25, 2018 at 7:17:03 PM UTC+2, sandeep patel wrote:
>
>
>
>
>
>
>
>
> *You can directly count days from date type.this belongs to datetime
> class.db.define_table('hotels', Field('Hotel'),
> Field('Bookin', 'date'), Field('Bookout', 'date'),
> Field('days', compute=lambda r: (r['Bookout']-r['Bookin']).days),
> Field('guests', 'integer'), Field('price', compute=lambda r:
> r['days']*r['guests']*650))Let me know if this will work for you.ThanksSP*
>
> On Thu, Oct 25, 2018 at 9:50 PM mostwanted <[email protected]
> <javascript:>> wrote:
>
>> I have 4 values that have to be calculated together to set a default
>> value for the fifth value, 2 of the 4 values are date values but the
>> problem is that calculating their difference leaves *days, 0:00:00* as
>> part of the answer but i only want the value number they give, is there a
>> way to strip away the *days, 0:00:00* from the date calculation answer
>> so i could use the remaining value in my calculation and get the answer i
>> want?
>>
>>
>> *Example Code*
>>
>>
>> *MODEL:*
>>
>>
>>
>>
>>
>>
>>
>>
>> *db.define_table('hotels', Field('Hotel'),
>> Field('Bookin', 'date'), Field('Bookout', 'date'),
>> Field('days', compute=lambda r: r['Bookout']-r['Bookin']),
>> Field('guests', 'integer'), Field('price', compute=lambda r:
>> r['days']*r['guests']*650))*
>>
>> Regards:
>>
>>
>> Mostwanted
>>
>> --
>> Resources:
>> - http://web2py.com
>> - http://web2py.com/book (Documentation)
>> - http://github.com/web2py/web2py (Source code)
>> - https://code.google.com/p/web2py/issues/list (Report Issues)
>> ---
>> 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] <javascript:>.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
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/d/optout.
