To obtain end of quarter months in VA

[Sultana]

Can you provide me with a code that shows only the end of quarter months March ,June, September, December and moves on in the future months my data stats from 2017.so That I can use it in the drop down menu, THIS IS FOR SAS VA

[Sam_SAS]

Hello,

I believe this type of expression is what you will be looking for:

( Month('Date by Month'n) In (3, 6, 9, 12) )

Is this the type of result you want?

What I did here was create a duplicate of 'Date by Month' and set its format to Month. This data item is assigned to the button bar. To show only the 4 end of quarter months in the button bar, I created a filter similar to the code I shared above. Then I created an interaction so that the list table would be filtered by the button bar. This might happen automatically for you, depending on how you create the button bar.

Let us know if that helps, or if you are looking for something different.

Thanks,

Sam

[touwen_k]

thank you Sam, it also helped me.

[Sam_SAS]

Great, thanks for letting us know 🙂