Hi everyone,

i keep getting this error:

File "/web2py/gluon/packages/dal/pydal/adapters/base.py", line 1544, in 
parse_date
    (y, m, d) = map(int, str(value)[:10].strip().split('-'))
ValueError: invalid literal for int() with base 10: '2016/04/12'


im basically submitting the form and searching a database for information 
between certain dates using DAL with a table. the table/date format is 
summarized as follows:

import datetime

today = datetime.datetime.today()

yesterday = today.date() - datetime.timedelta(days=1)

db = DAL(oracle:...........)

db.table('name', Field('startdt' , type = 'date' , default = yesterday, 
requires IS_DATE(format('%Y/%M/%D))),

                       Field('enddt', type = 'date' , default = today, requires 
IS_DATE(format('%Y/%M/%D))),

                       ......)


Im thinking it doesn't like the database has the format but not 100%. 


thank you





-- 
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.
For more options, visit https://groups.google.com/d/optout.

Reply via email to