Someone suggested that i try this: from datetime import datetime
(datetime.strptime(r['returning_date'], '%Y/%m/%d %H:%M') - datetime.strptime(r['loaning_date'], '%Y/%m/%d %H:%M')).days and it solved the problem https://stackoverflow.com/questions/57483293/how-to-calculate-the-number-of-days-between-dates-picked-on-a-date-picker-calend Regards; Mostwanted On Tuesday, August 13, 2019 at 11:35:55 PM UTC+2, Dave S wrote: > > > > 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 web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/2af0db96-839f-4217-855d-e610a1e43ea8%40googlegroups.com.
