1 Reply Latest reply: Jan 22, 2012 9:54 AM by Erich Shiino RSS

    Pls Help

    Shantnu Patel

      Hi

      Can any one help me and answer that how to set default selection when open sheet last 45 days data,date field is date2

        • Re: Pls Help
          Erich Shiino

          Hi,

          Please, check solution in the attachment

           

          I used a trigger on document 'on open' event.

           

          Go to settings ->Document properties -> Triggers and set the action there.

          The action is selection in the field (I called it Date) and the syntax is:

          ='>$(=date(today()-45))'

           

          It will generate a search string like this:

          >08/12/2011

           

          Hope this helps,

           

           

          Erich