How to select dates for the current month

[#1]

Hi QlikView experts,

I have a Date field "MM/DD/YY". I would like to pre-select dates that correspond to the current month OnActivateSheet.> Trigger action > Selection > Select in Field

Could you please help me to set up the right formula?

[Miguel_Angel_Baeyens]

Hi Soraya,

If you have a calendar table with dates and month fields, then select the month that corresponds to today, something like

Select in field: Month

Value: Month(Today())

Miguel

[maxgro · Accepted solution]

select in field           your date field

search string           ='>=$(=num(MonthStart(Today())))<=$(=num(MonthEnd(Today())))'

or

search string           ='>=$(=MonthStart(Today()))<=$(=MonthEnd(Today()))'