Use of [Today] in Rules

[Ben H]

Hi Alexander,

I am trying v4 which is looking good.

I have a ‘Status’ column and I’m trying to use a rule to store the date in a ‘Status Date’ column when the ‘Status’ is changed using a rule to set [Today]. This appears to work in v3.xx but in v4 I get an error in page. (Developer console shows: Object doesn’t support this property or method jquery-1.11.1.min.js, line 2 character 2966).

[Alexander Bautz]

Thank you for the feedback,
I have confirmed this bug. I will fix it and post the updated version during this weekend.

Alexander

[Alexander Bautz]

This issue is fixed in v4.100. Read the change log for details.

Alexander

[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.

[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]

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, 1 month ago by Ben H.
• This reply was modified 10 years, 1 month ago by Ben H.

[Alexander Bautz]

Hi,
I’m not sure this is possible, but you can use the jQueryUI datepicker like described here: https://spjsblog.com/forums/topic/jquery-ui-datepicker-widget-in-dffs/

Alexander

[Author]

Posts