Re: [web2py] Setting up database table with date.

2015-10-22 Thread Garry Smith
Hi I am using MySQL database, the default format for date is is -00-00, which is *-MM-DD*. I read you could change the format, which I tried with no effect. What I did in the end, is change all the dates in a spreadsheet to match -mm-dd, which then let me import the data. Thanks f

Re: [web2py] Setting up database table with date.

2015-10-21 Thread Johann Spies
On 20 October 2015 at 14:16, Garry Smith wrote: > 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. > Which database do you use and how is the date format specified in that database? Reg

[web2py] Setting up database table with date.

2015-10-20 Thread Garry Smith
Hi I have the following defining my DB tables:- db.define_table('school_students', Field('first_name', 'string',requires=IS_NOT_EMPTY()), Field('surname', 'string',requires=IS_NOT_EMPTY()), Field('year', 'string',requires=IS_NOT_EMPTY()), Field('form', 'string',requires=IS_NOT_EMP