On Tuesday, August 13, 2019 at 10:12:07 AM UTC-7, mostwanted wrote:
>
> My understanding of the error is that i can not subtract strings, which is
> true, but these fiends on which i am performing subtraction are dates and i
> was trying to pick their days when i put them into* ().days *so they
> wont be treated as strings because they are date fields, i cant figure out
> why it is not working!
>
They are date fields. Subtract them directly to get a datetime.timedelta
object:
compute = lambda r: {tdelta = r.returning_date - r.loaning_date; return
tdelta.days}
See Sec 8.1 (8.1.2, especially) of the Python standard Library
/dps
> On Tuesday, August 13, 2019 at 2:26:17 PM UTC+2, villas wrote:
>>
>> Check in DB what kind of field is '*daysLoaned*'. Maybe it is defined
>> as a Str field?
>> Try: Field('daysLoaned', compute=lambda r:
>> str(r['returning_date']-r['loaning_date']).days)
>> Just an idea...
>>
>>
>>
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/f4c3ccd5-1df3-45ee-8671-f47e7015cafc%40googlegroups.com.
