This seems to have solved my problem.
On Aug 26, 5:15 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> just to clarify. does this solve the original or you still have a
> problem? If you still have a problem, could you open a ticket on
> google code?
>
> Massimo
>
> On Aug 26, 5:12 pm, RipRyness <ripryn...@gmail.com> wrote:
>
>
>
> > What I did was create an en-us.py file in the languages folder.
> > {
> > 'use format yyyy-mm-dd': 'use format m/d/yyyy',
> > '%Y-%m-%d': '%m/%d/%Y',
> > '%Y-%m-%d %H:%M:%S': '%m/%d/%Y %H:%M:%S'
>
> > }
>
> > in my model I had this
> > ...
> > Field('dob', 'date', requires=[IS_DATE(format=T('%Y-%m-%d'),
> > error_message=T('use format yyyy-mm-dd')),
> > IS_NOT_EMPTY(error_message=T('value required'))],
> > widget=datepicker.widget),
> > ...
>
> > also my custom widget needed to set the "old_value" attribute so when
> > a form failed validation the widget could control the formatting
>
> > v = v if type(v)==type('') else f.formatter(v)
> > inp = SQLFORM.widgets.string.widget(f, v, _class="jqdate", _size="10",
> > old_value=v)
>
> > -Rip
>
> > On Aug 22, 11:52 pm, annet <annet.verm...@gmail.com> wrote:
>
> > > Here's an excerpt of my log that might be helpful:
>
> > > Formatting date
>
> > > Model file:
>
> > > 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 file:
>
> > > ... 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 file:
>
> > > ... 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'))))
>
> > > Kind regards,
>
> > > Annet.
