topic Re: Date in QlikView https://community.qlik.com/t5/QlikView/Date/m-p/1307442#M831085 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>Date([Duration Date] + [Duration of Project]) as ProjectEnd,</STRONG></P></BODY></HTML> Fri, 16 Jun 2017 18:05:48 GMT sunny_talwar 2017-06-16T18:05:48Z Date https://community.qlik.com/t5/QlikView/Date/m-p/1307440#M831083 <HTML><HEAD></HEAD><BODY><P>I have one qvw in which i have used inline</P><P>I have fields Duration Date &amp; Duration of project</P><P>IN Duration of date i have a specific date for ex <SPAN style="text-decoration: underline;"> 01/06/2017</SPAN></P><P>Duration of project such as 5,6,7,8,9 etc</P><P><STRONG>My requirement is the for 01/06/2017 if the Duration of project is 6 then it should display 01/12/2017 in new column</STRONG></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1307440#M831083 qlikcheepirishe 2020-11-25T16:16:04Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1307441#M831084 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><SPAN style="color: #800000; font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 10pt;">Date</SPAN><SPAN style="font-size: 10pt;">(<SPAN style="color: #800000;">[Duration Date]</SPAN>+<SPAN style="color: #800000;">[Duration of Project]</SPAN>,'MM/DD/YYYY')) <SPAN style="color: #0000ff;">AS</SPAN> </SPAN><SPAN style="color: #800000; font-size: 10pt;">[PROJECT LINE UP] </SPAN></SPAN></P><P></P><P><SPAN style="color: #800000; font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="color: #800000; font-size: 10pt;">Antonio</SPAN></P></BODY></HTML> Fri, 16 Jun 2017 18:05:34 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1307441#M831084 antoniotiman 2017-06-16T18:05:34Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1307442#M831085 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P><STRONG>Date([Duration Date] + [Duration of Project]) as ProjectEnd,</STRONG></P></BODY></HTML> Fri, 16 Jun 2017 18:05:48 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1307442#M831085 sunny_talwar 2017-06-16T18:05:48Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1307443#M831086 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167166_Capture.PNG" style="height: auto; width: auto;" /></P><P>In PROJECT LINE UP I WANT 'MMM/YYYY' HPW COME I CAN COME ACROSS ALSO FOR EX IF THE DOP IS 12 THEN IT SHOULD DISPLAY AS JUN/2018</P></BODY></HTML> Fri, 16 Jun 2017 18:33:40 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1307443#M831086 qlikcheepirishe 2017-06-16T18:33:40Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1307444#M831087 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167175_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Sat, 17 Jun 2017 04:06:22 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1307444#M831087 Anil_Babu_Samineni 2017-06-17T04:06:22Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1307445#M831088 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>I assume You Date Format is 'D/M/YYYY'</P><P>See Attachment.</P><P>Regards,</P><P>Antonio</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167202_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Sun, 18 Jun 2017 06:43:48 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1307445#M831088 antoniotiman 2017-06-18T06:43:48Z Re: Date https://community.qlik.com/t5/QlikView/Date/m-p/1307446#M831089 <HTML><HEAD></HEAD><BODY><P>Thanks for the kind guidance all </P></BODY></HTML> Mon, 19 Jun 2017 05:12:04 GMT https://community.qlik.com/t5/QlikView/Date/m-p/1307446#M831089 qlikcheepirishe 2017-06-19T05:12:04Z