I've translated it so translation looks like: %Y-%m-%d => %d.%m.%Y in view in input field date looks like %d.%m.%Y but after adding it becomes %Y-%m-%d you can test it here: http://84.201.238.210:8000/buh/book/view
On 22 июл, 01:18, mdipierro <mdipie...@cs.depaul.edu> wrote: > if you change the format of IS_DATE() you also need to change the > format for calendar.js. This is done in web2py_ajax.html. > > Alternatively you can leave IS_DATE and web2py_ajax.html as they were > and translate both strings using internationalization. > > Massimo > > On Jul 21, 9:16 am, DenisBY <denis....@gmail.com> wrote: > > > Hello > > > How I should define format if my controller looks like: > > def view(): > > form = SQLFORM(db.book) > > records = db(db.book.id>0).select(orderby='date') > > if form.accepts(request.vars): > > redirect(URL(r=request,f='view')) > > if form.errors: > > response.flash="error" > > return dict(form=form,records=records) > > > and in view: > > {{for record in records:}} > > <tr id="record-{{=record.id}}" class="record"> > > <td>{{=record.nn}}</td> > > <td>{{=record.name}}</td> > > <td>{{=record.num}}</td> > > <td>{{=record.date}}</td> > > <td>{{=record.operation}}</td> > > <td>{{=record.inc_sale}}</td> > > <td>{{=record.inc_copy}}</td> > > <td>{{=record.inc_other}}</td> > > <td>{{=int(record.inc_sale)+int(record.inc_copy)+int > > (record.inc_other)}}</td> > > <td><a href='{{=URL(r=request,f="d",args=[record.id])}}' > > class="delete" >X</a> > > </tr> > > {{pass}} > > > in input field date looks like I defined it (%d.%m.%Y), but after > > insertion, in view, it looks like defaul (%Y-%m-%d) > > > On 23 май, 09:47, annet.verm...@gmail.com wrote: > > > >Horst, > > > > Model: > > > > T.force('en-de') ## en-de is a language file you'll create below > > > > In the table definition: > > > > SQLField('fieldname', type='date') > > > > ... a validator on this field which reads like: > > > > db.tablename.fieldname.requires=IS_NULL_OR(IS_DATE(str(T('%Y-%m- > > > %d')))) > > > > Languages: > > > > ... create a language file e.g. en-de.py and edit the dates: > > > > Original Translation > > > %Y-%m-%d %d-%m-%Y > > > %Y-%m-%d %H:%M:%S %d-%m-%Y %H:%M:%S > > > > Click update. > > > > Views: > > > > ... to use the date in a view: > > > > {{=db.tablename.fieldname.formatter(tablename.fieldname)}} > > > > If you use form_factory to create a custom form, the code in the > > > controller should read: > > > > SQLField('fieldname',type='date',requires=IS_DATE(str(T('%Y-%m- > > > %d')))) > > > > I hope I did not leave anything out, if so, let me know. > > > > Kind regards, > > > Annet. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---