topic Help with Dates in QlikView https://community.qlik.com/t5/QlikView/Help-with-Dates/m-p/222083#M74829 <HTML><HEAD></HEAD><BODY><P>Looking for some help on dates...</P><P>I have a field called "pdr_DueDateBasis" which, depending on the receipt status, is either our actual receipt date or an estimated receipt date for goods in transit to us.</P><P>Using my vendor business terms table, I am trying to work out when payment is due based on this field.</P><P>The scenario (of which there are many) I am working on revolves around two further fields...</P><P>bus_ProxyDiscountDayOfMonth e.g. 15</P><P>bus_ProxyDiscountMonthPlus e.g. 2</P><P>So if I had a receipt date of 04/02/2011 (dd/mm/yyyy format) my payment due date using the above example figures would be the 15/04/2011.</P><P>My "If" statement to try and construct this date in my script is as follows...</P><P>*** Code Starts ***</P><P>IF(bus_Proxy = 'Yes' AND bus_ProxyDiscountFixedDate = 'Blank' AND bus_ProxyDiscountDayOfMonth &lt;&gt; 31,<BR /><BR /> Date(<BR /><BR /> // Day<BR /><BR /> bus_ProxyDiscountDayOfMonth &amp; '/' &amp;<BR /><BR /> // Month and Year<BR /><BR /> addmonths(Date(pdr_DateDueBasis, 'MM/YYYY'), bus_ProxyDiscountMonthPlus)</P><P>, 'DD/MM/YYYY')</P><P>*** Code Ends ***</P><P>Any assitance greatly appreciated...</P><P>Regards</P><P>Paul</P></BODY></HTML> Fri, 18 Feb 2011 16:39:47 GMT pkelly 2011-02-18T16:39:47Z Help with Dates https://community.qlik.com/t5/QlikView/Help-with-Dates/m-p/222083#M74829 <HTML><HEAD></HEAD><BODY><P>Looking for some help on dates...</P><P>I have a field called "pdr_DueDateBasis" which, depending on the receipt status, is either our actual receipt date or an estimated receipt date for goods in transit to us.</P><P>Using my vendor business terms table, I am trying to work out when payment is due based on this field.</P><P>The scenario (of which there are many) I am working on revolves around two further fields...</P><P>bus_ProxyDiscountDayOfMonth e.g. 15</P><P>bus_ProxyDiscountMonthPlus e.g. 2</P><P>So if I had a receipt date of 04/02/2011 (dd/mm/yyyy format) my payment due date using the above example figures would be the 15/04/2011.</P><P>My "If" statement to try and construct this date in my script is as follows...</P><P>*** Code Starts ***</P><P>IF(bus_Proxy = 'Yes' AND bus_ProxyDiscountFixedDate = 'Blank' AND bus_ProxyDiscountDayOfMonth &lt;&gt; 31,<BR /><BR /> Date(<BR /><BR /> // Day<BR /><BR /> bus_ProxyDiscountDayOfMonth &amp; '/' &amp;<BR /><BR /> // Month and Year<BR /><BR /> addmonths(Date(pdr_DateDueBasis, 'MM/YYYY'), bus_ProxyDiscountMonthPlus)</P><P>, 'DD/MM/YYYY')</P><P>*** Code Ends ***</P><P>Any assitance greatly appreciated...</P><P>Regards</P><P>Paul</P></BODY></HTML> Fri, 18 Feb 2011 16:39:47 GMT https://community.qlik.com/t5/QlikView/Help-with-Dates/m-p/222083#M74829 pkelly 2011-02-18T16:39:47Z Help with Dates https://community.qlik.com/t5/QlikView/Help-with-Dates/m-p/222084#M74830 <HTML><HEAD></HEAD><BODY><P>Is make date a better approach for this?</P></BODY></HTML> Fri, 18 Feb 2011 20:01:12 GMT https://community.qlik.com/t5/QlikView/Help-with-Dates/m-p/222084#M74830 pkelly 2011-02-18T20:01:12Z Help with Dates https://community.qlik.com/t5/QlikView/Help-with-Dates/m-p/222085#M74831 <HTML><HEAD></HEAD><BODY><P>Finally got it....</P><P>Used...</P><P>IF(bus_Proxy = 'Yes' AND bus_ProxyDiscountFixedDate = 'Blank' AND bus_ProxyDiscountDayOfMonth &lt;&gt; 31,<BR /> makedate(<BR /> Year(addmonths(Date(pdr_DateDueBasis, 'DD/MM/YYYY'), bus_ProxyDiscountMonthPlus)),<BR /> Month(addmonths(Date(pdr_DateDueBasis, 'DD/MM/YYYY'), bus_ProxyDiscountMonthPlus)),<BR /> bus_ProxyDiscountDayOfMonth)</P></BODY></HTML> Mon, 21 Feb 2011 09:23:23 GMT https://community.qlik.com/t5/QlikView/Help-with-Dates/m-p/222085#M74831 pkelly 2011-02-21T09:23:23Z