topic Re: Get Max and Min Date from selected calendar in QlikView https://community.qlik.com/t5/QlikView/Get-Max-and-Min-Date-from-selected-calendar/m-p/1120153#M887998 <HTML><HEAD></HEAD><BODY><P>Is Min(Date) and Max(Date) not working for you?</P></BODY></HTML> Wed, 31 Aug 2016 09:25:03 GMT sunny_talwar 2016-08-31T09:25:03Z Get Max and Min Date from selected calendar https://community.qlik.com/t5/QlikView/Get-Max-and-Min-Date-from-selected-calendar/m-p/1120152#M887997 <HTML><HEAD></HEAD><BODY><P>I have three lists as below image shows (one for years, another for months, and another for days of month):</P><P></P><P><IMG alt="CALENDAR.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/136108_CALENDAR.png" style="height: auto;" /></P><P></P><P>From this, I am trying to get the Min(Date) and Max(Date) selected in the calendar, for example, from above image, Min(Date) would be 01/01/2014 and Max(Date) would be 03/01/2014. So how can I obtain these values? I need to obtain these values to use them in an aggr function.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-Max-and-Min-Date-from-selected-calendar/m-p/1120152#M887997 2020-11-25T16:16:04Z Re: Get Max and Min Date from selected calendar https://community.qlik.com/t5/QlikView/Get-Max-and-Min-Date-from-selected-calendar/m-p/1120153#M887998 <HTML><HEAD></HEAD><BODY><P>Is Min(Date) and Max(Date) not working for you?</P></BODY></HTML> Wed, 31 Aug 2016 09:25:03 GMT https://community.qlik.com/t5/QlikView/Get-Max-and-Min-Date-from-selected-calendar/m-p/1120153#M887998 sunny_talwar 2016-08-31T09:25:03Z Re: Get Max and Min Date from selected calendar https://community.qlik.com/t5/QlikView/Get-Max-and-Min-Date-from-selected-calendar/m-p/1120154#M887999 <HTML><HEAD></HEAD><BODY><P>If you've done things the smart way then those year, month and day fields are based on a date field from your data model. And if that's the case then they will be linked to that data model and you can simply use min(<EM>YourDateFieldHere</EM>) and max(<EM>YourDateFieldHere</EM>) to get the values you're asking about.</P></BODY></HTML> Wed, 31 Aug 2016 09:26:26 GMT https://community.qlik.com/t5/QlikView/Get-Max-and-Min-Date-from-selected-calendar/m-p/1120154#M887999 Gysbert_Wassenaar 2016-08-31T09:26:26Z Re: Get Max and Min Date from selected calendar https://community.qlik.com/t5/QlikView/Get-Max-and-Min-Date-from-selected-calendar/m-p/1120155#M888000 <HTML><HEAD></HEAD><BODY><P>I forgot for a moment that these fields are based on my data model and I can access them as I do for other fields.... </P></BODY></HTML> Thu, 01 Sep 2016 00:07:47 GMT https://community.qlik.com/t5/QlikView/Get-Max-and-Min-Date-from-selected-calendar/m-p/1120155#M888000 2016-09-01T00:07:47Z