Button for Current Quarter/Year

[jeckstein]

I have a filed called Quarter Year and I need to create a button using the action toggle select. I need the button to select the current quarter-year.

The field I am selecting from is called "QuarterYear" and is formatted like

Q1-16

Q2-16

Q3-16

Q4-16

Q1-17

Since today is 01-13-2017 the button should toggle select Q1-17.

thanks in advance

[MK_QSL]

Like this?

[sunny_talwar · Accepted solution]

May be like this

Field

QuarterYear

SearchString

'Q' & Ceil(Month(Today())/3) & '-' & Date(Today(), 'YY')

[jeckstein]

Perfect. Thanks