[Ben H]

Thanks. I want a row that has the same label and data cells as the rest of the table – as used for the buttons on this form.

[Ben H]

I am now using the French(Canadian) locale in my SharePoint to display dates in the global ISO YYYY-MM-DD format generally across the site. The only issue I appear to have is that the date picker is in French. Do you know how I can easily change the LCID for the date picker iframe using jquery?

I want to change lcid=3084 to LCID=1033 in

<a href="#" onclick="clickDatePicker(&quot;ctl00_m_g_867d1b33_1f64_4674_8c14_ff4805b3437d_ctl00_ctl05_ctl05_ctl00_ctl00_ctl04_ctl00_ctl00_DateTimeField_DateTimeFieldDate&quot;, &quot;\u002fsites\u002fPTAS\u002f_layouts\u002fiframe.aspx?&cal=1&lcid=3084&langid=1033&tz=00:59:59.9993897&ww=0111110&fdow=1&fwoy=2&hj=0&swn=True&minjday=109207&maxjday=2666269&date=&quot;, &quot;2014-10-01&quot;, event);return false;"><img id="ctl00_m_g_867d1b33_1f64_4674_8c14_ff4805b3437d_ctl00_ctl05_ctl05_ctl00_ctl00_ctl04_ctl00_ctl00_DateTimeField_DateTimeFieldDateDatePickerImage" src="/_layouts/images/calendar.gif" border="0" alt="Select a date from the calendar."></a>

I tried

function changeLocale(){
$('lcid=3084').replaceWith($('lcid=1033'));
}

without success. Thanks

• This reply was modified 10 years, 2 months ago by Ben H.
• This reply was modified 10 years, 2 months ago by Ben H.

[Ben H]

I also tried the French(Canadian) locale to get the ISO date format 2014-09-13 – and the [Today] function is giving 2014-9-13

[Ben H]

Thanks. There is a (minor) slightly strange behaviour – in UK locale the date format is DD/MM/YYYY. Using the date picker puts the date in this format, as does using the built-in SharePoint default [Today] in the column settings. Using [Today] in a DFFS rule results the D/M/YYYY format in the form field.

[Author]

Posts