topic Re: create a calender using two date fields in QlikView https://community.qlik.com/t5/QlikView/create-a-calender-using-two-date-fields/m-p/648729#M673667 <HTML><HEAD></HEAD><BODY><P>Have a look at this post from&nbsp; <A href="https://community.qlik.com/qlik-users/115885">Jonas Valleskog</A></P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-6502#comment-16696">http://community.qlik.com/docs/DOC-6502#comment-16696</A></P><P><BR /> </P></BODY></HTML> Mon, 08 Sep 2014 15:42:11 GMT Colin-Albert 2014-09-08T15:42:11Z create a calender using two date fields https://community.qlik.com/t5/QlikView/create-a-calender-using-two-date-fields/m-p/648727#M673665 <HTML><HEAD></HEAD><BODY><P>I would like to know how to create a calender using three date fields from same table?</P><P></P><P></P><P>Budget:</P><P>LOAD BUDGET_ENTITY, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; PROJ_MGR_RC, </P><H6>&nbsp;&nbsp;&nbsp; Date(CFAS_START_DATE, 'MM/DD/YYYY') AS CFAS_START_DT, </H6><H6>&nbsp;&nbsp;&nbsp;&nbsp; Date(CFAS_EST_IN_SERVICE_DATE, 'MM/DD/YYYY') AS CFAS_EST_IN_SERV_DT,</H6><H6>&nbsp;&nbsp;&nbsp;&nbsp; CFAS_CLOSED_DATE</H6><P>FROM</P><P>Budget_details;</P><P></P><P>I want to create a calender using the following columns.</P><H6>CFAS_START_DT</H6><H6>CFAS_EST_IN_SERV_DT</H6><H6>CFAS_CLOSED_DATE</H6><P></P><P>Thank You.</P></BODY></HTML> Mon, 08 Sep 2014 15:36:38 GMT https://community.qlik.com/t5/QlikView/create-a-calender-using-two-date-fields/m-p/648727#M673665 2014-09-08T15:36:38Z Re: create a calender using two date fields https://community.qlik.com/t5/QlikView/create-a-calender-using-two-date-fields/m-p/648728#M673666 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date">http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date</A></P></BODY></HTML> Mon, 08 Sep 2014 15:40:41 GMT https://community.qlik.com/t5/QlikView/create-a-calender-using-two-date-fields/m-p/648728#M673666 MK_QSL 2014-09-08T15:40:41Z Re: create a calender using two date fields https://community.qlik.com/t5/QlikView/create-a-calender-using-two-date-fields/m-p/648729#M673667 <HTML><HEAD></HEAD><BODY><P>Have a look at this post from&nbsp; <A href="https://community.qlik.com/qlik-users/115885">Jonas Valleskog</A></P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-6502#comment-16696">http://community.qlik.com/docs/DOC-6502#comment-16696</A></P><P><BR /> </P></BODY></HTML> Mon, 08 Sep 2014 15:42:11 GMT https://community.qlik.com/t5/QlikView/create-a-calender-using-two-date-fields/m-p/648729#M673667 Colin-Albert 2014-09-08T15:42:11Z