Use of [Today] in Rules

Forums Dynamic Forms for SharePoint Use of [Today] in Rules

Viewing 5 reply threads
  • Author
    Posts
    • #6145
      Ben H
      Participant

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

    • #6148
      Alexander Bautz
      Keymaster

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

      Alexander

    • #6153
      Alexander Bautz
      Keymaster

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

      Alexander

    • #6163
      Ben H
      Participant

      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.

      • #6164
        Ben H
        Participant

        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

    • #6295
      Ben H
      Participant

      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 5 years, 10 months ago by Ben H.
      • This reply was modified 5 years, 10 months ago by Ben H.
    • #6310
      Alexander Bautz
      Keymaster

      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

Viewing 5 reply threads
  • You must be logged in to reply to this topic.