on open trigger

[kunkumnaveen]

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

[avinashelite]

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 

[settu_periasamy]

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