2 Replies Latest reply: Dec 5, 2012 5:58 AM by Simon Goodman RSS

    Preselect a date on opening a document

    Simon Goodman

      I want the document on opening to select the last data working week. I know about Document Properties/Triggers/Document Event Trigger/OnOpenHasAction. So for example for Oct to Sep as the financial year if the last working date is 16/11/2012 then the working week should be 7.

       

      My problem is I have target data till 30/09/2013, so =maxstring(week) would return week 52. I have tried a number of ideas unsucessfully including a version of =Weektoday().

       

      Please can someone point me in the right direction. The script is attached.