Select in Field Action for All months YTD

[james]

Anyone have an option to select the current YTD months for select in Fields in v9?

I would like the Select in Field Action to select Jan and Feb. since today is February... Any ideas?

[disqr_rm]

You should create a YTD_Flag field in your data with value of 0 or 1. Then you can have field action and select 1 value for this new field. When you do that all months in YTD will be selected. Just one way of handle it.

[qvwarning]

Select in Field Action with Set Analysis

In my example: month(today()) = 6 = june

Specified Field: [Time Month] as numeric

Search Expression: ='>=1<=$(=Num(Month(Today())))'

my advanced search expression is shown in the Current selections box as:

Time Month      >=1<=6

[#4]

Hi,

See the attachment.