Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
HI Nikhil,
may be you should set the trigger at Document Level as an 'On Open'.
HTH - Andy
I tried that also, but still not working.
I have set following triggers:
Set variable: vStartDate
Set Variable: vEndDate
Select In field: Trans_Date
try to use for variable definition
max({1}Trans_Date)
you get max date independant from any selections