2 Replies Latest reply: Aug 16, 2016 2:55 PM by Settu Periyasasamy 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


      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



        • 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 Periyasasamy

            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