[web2py] sqlform date field format broken after validation fails

[Maria Mitica]

Hello

I have the following problem:
 - i have a sqlform with a date field (which I customized with a jquery 
widget, that, among other things, changes the date format into dd/mm/yy) 
which works fine (displays the correct format after date selection) but if 
the form validation fails than the "saved" value of the date field gets 
reformatted back to '%Y-%m-%d' default format.

this is the field value in the table:

Field('data', 'date', widget=date_widget, 
requires=[IS_NOT_EMPTY(error_message="Completarea campului este 
obligatorie"),
                                                                       
IS_DATE('%d/%m/%Y', error_message = 'Data trebuie sa aiba formatul 
ZZ/LL/AAAA') ],
        label="Data Nasterii", comment="")

db.table.data.represent = lambda value,row : value.strftime('%d/%m/%Y')

and the date widget:

def date_widget(f, v):
    wrapper = DIV()
    inp = SQLFORM.widgets.string.widget(f, v, _class="jqdate")
    jqscr = SCRIPT(
        "jQuery(document).ready(function(){\
                        jQuery('#%s').datepicker({\
                            dateFormat:'dd/mm/yy',\
                            showOtherMonths:true,\
                            selectOtherMonths:true,\
                            changeYear:true,\
                            yearRange: '-80:+0',\
                            changeMonth:true\
                            });\
                        });" % inp['_id'],
        _type="text/javascript")
    wrapper.components.extend([inp, jqscr])
    return wrapper

also i have included the translation in my language file:
'%Y-%m-%d' : '%d/%m/%Y',
'%Y-%m-%d %H:%M:%S': '%d/%m/%Y %H:%M:%S',
'%d.%m.%Y': '%d.%m.%Y',
'%d.%m.%Y %H:%M:%S': '%d.%m.%Y %H:%M:%S',
'%d/%m/%Y': '%d/%m/%Y',
'%d/%m/%Y %H:%M:%S': '%d/%m/%Y %H:%M:%S',

and changed the default format in web2py_ajax.html:
    var w2p_ajax_date_format = "{{=T('%d/%m/%Y')}}";
    var w2p_ajax_datetime_format = "{{=T('%d/%m/%Y %H:%M:%S')}}";

i'm running out of ideas so i thought maybe you could help.

thanks
'web2py newbie' :)


--