Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get it in variable . The selection in filter.
See the screenshot
For eg,
vExample should contain 2017Mar
Sample attached.
=GetFieldSelections([Planning Year]) & GetFieldSelections([Planning Month])
=GetFieldSelections([Planning Year]) & GetFieldSelections([Planning Month])
=Date#(max([Planning Year])&Date(Max(Date#([Planning Month],'MMM')),'MMM'),'YYYYMM')
I added two triggers... 1 to Planning Year Field and the other one to Planning Month field to get this.
This was the reply I was typing, but have been ninja'd again!
Create the variable vExample
Go to Settings|Document Properties|Triggers
For both Planning Year and Planning Month
Add an Action for On Select
Choose Add|External|Set Variable
Enter the variable name vExample
Enter =GetFieldSelections([Planning Year])&GetFieldSelections([Planning Month]) as the Value