date format of date picker

[Rohit Raj Sharma]

I have form with date field i have setup default format(dd/mm/yyyy). i am using web2py sqlform. when i select date from date picker. it used to take dd/mm/yy. i know its very silly question. i had tried in ajax.html file and check my db file also but i am not able to find the solution. can any one help me to solve.

i set default value: dd/mm/yyyy.

when i edit the date it change to dd/mm/yy

my ajax file

<script type="text/javascript"><!--

    // These variables are used by the web2py_ajax_init function in web2py_ajax.js (which is loaded below).

    var w2p_ajax_confirm_message = "{{=T('Are you sure you want to delete this object?')}}";

    var w2p_ajax_disable_with_message = "{{=T('Working...')}}";

    var w2p_ajax_date_format = "{{=T('%d-%m-%y')}}";

    var w2p_ajax_datetime_format = "{{=T('%Y-%m-%d %H:%M:%S')}}";

    var ajax_error_500 = '{{=T.M('An error occured, please [[reload %s]] the page') % URL(args=request.args, vars=request.get_vars) }}'

    //--></script>

{{

response.files.insert(0,URL('static','js/jquery.js'))

response.files.insert(1,URL('static','css/calendar.css'))

response.files.insert(2,URL('static','js/calendar.js'))

response.files.insert(3,URL('static','js/web2py.js'))

response.include_meta()

response.include_files()

}}

[Annet]

What about the validator:

isdate = dict(type='date', requires=IS_DATE(format='%d-%m-%Y', error_message='Formaat komt niet overeen met dd-mm-yyyy'),
              represent=lambda v: v.strftime('%d/%m/%Y') if v else '')


Kind regards,

Annet