12 month rolling selection from a field not in data format

[qv_bazz_10]

Hi guys,

i'm trying to create a button to select previous 12 month rolling from a field that has value not in data format.

The name of the field is ANNO_MESE, here is a screenshot of a list box (YYYYMM not in data format):

What i'd like to have is a button (or even something else) to activate selection on previous 12 months based on current month, so, for example:

today (october 2017) -> button activate selection on the field ANNO_MESE from 201610 to 201709

tomorrow (novembre 2017) -> button activate selection on the field ANNO_MESE from 201611 to 201710

Unfortunately, i can't edit the script or create new variables (it's a shared document).

Is there a way to do it?

Thanks in advance to everybody,

Andrea

[trdandamudi · Accepted solution]

see if the below helps: ( I am using Version 12)

[qv_bazz_10]

Thirumala, it's simply perfect!!! Thank you very much, you've been incredibly fast and kind!

Andrea

[trdandamudi]

You are welcome and glad I am able to help...