Use of [Today] in Rules

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

This topic contains 6 replies, has 2 voices, and was last updated by  Alexander Bautz 4 years, 7 months ago.

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

You must be logged in to reply to this topic.