topic Re: How to select dates for the current month in QlikView https://community.qlik.com/t5/QlikView/How-to-select-dates-for-the-current-month/m-p/657946#M240144 <HTML><HEAD></HEAD><BODY><P>select in field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; your date field</P><P>search string&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ='&gt;=$(=num(MonthStart(Today())))&lt;=$(=num(MonthEnd(Today())))'</P><P></P><P>or </P><P>search string&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ='&gt;=$(=MonthStart(Today()))&lt;=$(=MonthEnd(Today()))'</P></BODY></HTML> Mon, 11 Aug 2014 17:01:03 GMT maxgro 2014-08-11T17:01:03Z How to select dates for the current month https://community.qlik.com/t5/QlikView/How-to-select-dates-for-the-current-month/m-p/657944#M240142 <HTML><HEAD></HEAD><BODY><P>Hi QlikView experts,</P><P></P><P>I have a Date field "MM/DD/YY". I would like to pre-select dates that correspond to the current month OnActivateSheet.&gt; Trigger action &gt; Selection &gt; Select in Field</P><P></P><P>Could you please help me to set up the right formula?</P></BODY></HTML> Mon, 11 Aug 2014 16:04:07 GMT https://community.qlik.com/t5/QlikView/How-to-select-dates-for-the-current-month/m-p/657944#M240142 2014-08-11T16:04:07Z Re: How to select dates for the current month https://community.qlik.com/t5/QlikView/How-to-select-dates-for-the-current-month/m-p/657945#M240143 <HTML><HEAD></HEAD><BODY><P>Hi Soraya,</P><P>If you have a calendar table with dates and month fields, then select the month that corresponds to today, something like</P><P>Select in field: Month</P><P>Value: Month(Today())</P><P>Miguel</P></BODY></HTML> Mon, 11 Aug 2014 16:30:30 GMT https://community.qlik.com/t5/QlikView/How-to-select-dates-for-the-current-month/m-p/657945#M240143 Miguel_Angel_Baeyens 2014-08-11T16:30:30Z Re: How to select dates for the current month https://community.qlik.com/t5/QlikView/How-to-select-dates-for-the-current-month/m-p/657946#M240144 <HTML><HEAD></HEAD><BODY><P>select in field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; your date field</P><P>search string&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ='&gt;=$(=num(MonthStart(Today())))&lt;=$(=num(MonthEnd(Today())))'</P><P></P><P>or </P><P>search string&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ='&gt;=$(=MonthStart(Today()))&lt;=$(=MonthEnd(Today()))'</P></BODY></HTML> Mon, 11 Aug 2014 17:01:03 GMT https://community.qlik.com/t5/QlikView/How-to-select-dates-for-the-current-month/m-p/657946#M240144 maxgro 2014-08-11T17:01:03Z