2 Replies Latest reply: Aug 16, 2016 2:55 PM by Settu Periyasamy RSS

    on open trigger

    naveen kumar

      Hello All

      How to get select multiple dates on opening  the application

      i got a Date field data like this

      Date

      03 Jan

      04 Jan

      .

      .

      .

      30 Jan......

       

      i wrote two Triggers(on open)

      1)select in field ----->Date

                                    23 Jan


      2) Select in field ---->Date

                                   ='<=$(=Date(Date,'DD MMM YYYY'))'  which is not working


      o/p i am looking is on open the document

      i need this           03 Jan   <= 23 Jan



        thanks

      naveen

        • Re: on open trigger
          Avinash R

          Naveen, one easy way is to set a flag in the script for the values where you need to select the dates and then set a on open trigger to select the value 1 i.e. the flag field which will be a easy way to handle 

          • Re: on open trigger
            Settu Periyasamy

            You can assign the value into the variable and you can use that in your trigger. for e.g

             

            Variable Name :  vMin

            Value :  =Date(Date#('03 Jan 2016','DD MMM YYYY'),'DD MMM YYYY')

             

            Variable Name : vMax

            Value :  =Date(Date#('23 Jan 2016','DD MMM YYYY'),'DD MMM YYYY')  // You can change this as dynamic instead of hard code date

             

            In your trigger, you can try like

            search string would be ,    ='>='&vMin&'<='&vMax