do not use
{{=row.datefield}}
use
{{=db.table.datetfield.formatter(row.datefield)}}
On Jul 22, 8:22 am, DenisBY <denis....@gmail.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
