topic Re: Date with sum nums in QlikView https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144035#M374513 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>I put:</P><P></P><P>Num#(Date([Fecha Inicio],'YYYY-MM-DD'), '##') +1 as SumDATEPRUEBA2, But fiel is turn null</P><P></P><P>Changed <SPAN style="font-size: 13.3333px;">YYYYMMDD for </SPAN><SPAN style="font-size: 13.3333px;">YYYY-MM-DD because the format is that.</SPAN></P></BODY></HTML> Tue, 07 Jun 2016 16:31:49 GMT pgalvezt 2016-06-07T16:31:49Z Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144032#M374510 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would to show my date with sum nums in date format, like</P><P></P><P></P><P>[Fecha Inicio] +0 as SumDATEPRUEBA,</P><P><SPAN style="font-size: 13.3333px;">[Fecha Inicio] +1 as SumDATEPRUEBA1, and so on....</SPAN></P><P></P><P>Num#([Fecha Inicio],'YYYYMMDD') as SumDATEPRUEBA2 (This bring the same I think in text Format)</P></BODY></HTML> Tue, 07 Jun 2016 16:22:01 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144032#M374510 pgalvezt 2016-06-07T16:22:01Z Re: Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144033#M374511 <HTML><HEAD></HEAD><BODY><P>How about this:</P><P></P><P><STRONG>Date([Fecha Inicio],'YYYYMMDD') as SumDATEPRUEBA2</STRONG></P></BODY></HTML> Tue, 07 Jun 2016 16:24:28 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144033#M374511 sunny_talwar 2016-06-07T16:24:28Z Re: Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144034#M374512 <HTML><HEAD></HEAD><BODY><P>Or this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Num([Fecha Inicio]</STRONG><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">) as SumDATEPRUEBA2</STRONG></P><P></P><P>or</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Num#(Date([Fecha Inicio],'YYYYMMDD'), '##') as SumDATEPRUEBA2</STRONG></P></BODY></HTML> Tue, 07 Jun 2016 16:26:28 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144034#M374512 sunny_talwar 2016-06-07T16:26:28Z Re: Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144035#M374513 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>I put:</P><P></P><P>Num#(Date([Fecha Inicio],'YYYY-MM-DD'), '##') +1 as SumDATEPRUEBA2, But fiel is turn null</P><P></P><P>Changed <SPAN style="font-size: 13.3333px;">YYYYMMDD for </SPAN><SPAN style="font-size: 13.3333px;">YYYY-MM-DD because the format is that.</SPAN></P></BODY></HTML> Tue, 07 Jun 2016 16:31:49 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144035#M374513 pgalvezt 2016-06-07T16:31:49Z Re: Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144036#M374514 <HTML><HEAD></HEAD><BODY><P>How about this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Num#(Date([Fecha Inicio] + 1,'YYYY-MM-DD'), '##') as SumDATEPRUEBA2</STRONG></SPAN></P></BODY></HTML> Tue, 07 Jun 2016 16:33:10 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144036#M374514 sunny_talwar 2016-06-07T16:33:10Z Re: Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144037#M374515 <HTML><HEAD></HEAD><BODY><P>Is reading as text because the date is in the left. Everyting else is ok.</P></BODY></HTML> Tue, 07 Jun 2016 16:38:59 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144037#M374515 pgalvezt 2016-06-07T16:38:59Z Re: Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144038#M374516 <HTML><HEAD></HEAD><BODY><P>Can you try this:</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Num#(Date([Fecha Inicio] + 1,'YYYYMMDD'), '##') as SumDATEPRUEBA2</STRONG></P></BODY></HTML> Tue, 07 Jun 2016 16:43:26 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144038#M374516 sunny_talwar 2016-06-07T16:43:26Z Re: Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144039#M374517 <HTML><HEAD></HEAD><BODY><P>Lets actually take a step back. What exactly do you want?</P><P></P><P>Input&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Output?</P><P>14-12-2015&nbsp;&nbsp;&nbsp;&nbsp; 20151412 (Number Formated or Date Formatted)</P></BODY></HTML> Tue, 07 Jun 2016 16:44:35 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144039#M374517 sunny_talwar 2016-06-07T16:44:35Z Re: Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144040#M374518 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Input&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Output?</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">14-12-2015&nbsp;&nbsp;&nbsp;&nbsp; 15-12-2015</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Fecha Inicio +1&nbsp; </P></BODY></HTML> Tue, 07 Jun 2016 16:45:36 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144040#M374518 pgalvezt 2016-06-07T16:45:36Z Re: Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144041#M374519 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Date(Date#([Fecha Inicio], 'DD-MM-YYYY') + 1,'DD-MM-YYYY') as SumDATEPRUEBA2</STRONG></P><P></P><P>or if the date is read properly, then this:</P><P></P><P><STRONG>Date([Fecha Inicio] + 1,'DD-MM-YYYY') as SumDATEPRUEBA2</STRONG></P></BODY></HTML> Tue, 07 Jun 2016 16:47:44 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144041#M374519 sunny_talwar 2016-06-07T16:47:44Z Re: Date with sum nums https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144042#M374520 <HTML><HEAD></HEAD><BODY><P>Perfect:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Date(Date#([Fecha Inicio], 'DD-MM-YYYY') + 1,'DD-MM-YYYY') as SumDATEPRUEBA2</STRONG></P></BODY></HTML> Tue, 07 Jun 2016 16:53:39 GMT https://community.qlik.com/t5/QlikView/Date-with-sum-nums/m-p/1144042#M374520 pgalvezt 2016-06-07T16:53:39Z