How to get it in variable ?

[suvechha_b]

How to get it in variable . The selection in filter.

See the screenshot

For eg,

vExample should contain 2017Mar

Sample attached.

[ciaran_mcgowan · Accepted solution]

=GetFieldSelections([Planning Year]) & GetFieldSelections([Planning Month])

[MK_QSL]

=Date#(max([Planning Year])&Date(Max(Date#([Planning Month],'MMM')),'MMM'),'YYYYMM')

[sunny_talwar]

I added two triggers... 1 to Planning Year Field and the other one to Planning Month field to get this.

[ThornOfCrowns]

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