Trigger not working

[nikhilgarg]

Hey,

My on activate sheet trigger not working.

I have 2 var: vStart and vEndDate

On activate sheet trigget, i set:

vStartDate: Max(Trans_Date)

vEndDate:  Max(Trans_Date)

Then, select in field: TRANS_DATE as: ='>='& date(vStartDate) & '<=' & date(vEndDate)

But when i open the document, i dont get max date selected and corresponding data.

Where am i wrong?

[awhitfield]

HI Nikhil,

may be you should set the trigger at Document Level as an 'On Open'.

HTH - Andy

[nikhilgarg]

I tried that also, but still not working.

I have set following triggers:

Set variable: vStartDate

Set Variable: vEndDate

Select In field: Trans_Date

[Anonymous]

try to use for variable definition

max({1}Trans_Date)

you get max date independant from any selections