topic Re: Making a new date from existing date in QlikView

topic Re: Making a new date from existing date in QlikView https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707107#M1063956 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P> </P><P><SPAN style="font-size: 8pt;">= Date(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">())+5)  </SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Or</SPAN></P><P><SPAN style="font-size: 8pt;">Date(Today() + 5)</SPAN></P><P></P></BODY></HTML> Tue, 16 Sep 2014 10:55:58 GMT MayilVahanan 2014-09-16T10:55:58Z Making a new date from existing date https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707106#M1063953 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I am having a date field say Date and number of days say Days. Now I have to create a new date by combining Date+Days.</P><P></P><P>Example: Date is : 15th Sep 2014 and Days: 20</P><P></P><P>Now NewDate would be 15th Sep 2014 + 20= 5th Oct. 2014.</P><P></P><P>Pls suggest.</P><P></P><P>Is is possible through MakeDate??</P><P></P><P>Regards,</P><P>Balraj</P></BODY></HTML> Tue, 16 Sep 2014 10:48:08 GMT https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707106#M1063953 Anonymous 2014-09-16T10:48:08Z Re: Making a new date from existing date https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707107#M1063956 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P> </P><P><SPAN style="font-size: 8pt;">= Date(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Today</SPAN><SPAN style="font-size: 8pt;">())+5)  </SPAN></P><P> </P><P><SPAN style="font-size: 8pt;">Or</SPAN></P><P><SPAN style="font-size: 8pt;">Date(Today() + 5)</SPAN></P><P></P></BODY></HTML> Tue, 16 Sep 2014 10:55:58 GMT https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707107#M1063956 MayilVahanan 2014-09-16T10:55:58Z Re: Making a new date from existing date https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707108#M1063959 <HTML><HEAD></HEAD><BODY><P>Date(Date+Days, 'DD MMM YYYY')</P></BODY></HTML> Tue, 16 Sep 2014 11:03:05 GMT https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707108#M1063959 MarcoWedel 2014-09-16T11:03:05Z Re: Making a new date from existing date https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707109#M1063962 <HTML><HEAD></HEAD><BODY><P>or just</P><P></P><P>Date(Date+Days)</P><P></P><P>if you already set an appropriate dateformat in your script variable "DateFormat".</P></BODY></HTML> Tue, 16 Sep 2014 11:05:21 GMT https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707109#M1063962 MarcoWedel 2014-09-16T11:05:21Z Re: Making a new date from existing date https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707110#M1063965 <HTML><HEAD></HEAD><BODY><P>=LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),</P><P>  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-9) & </P><P></P><P>  IF(</P><P>  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),</P><P>  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '1' or</P><P>  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),</P><P>  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '21' or</P><P>  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),</P><P>  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '31','st ',</P><P></P><P>  IF(</P><P>  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),</P><P>  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '2' or</P><P>  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),</P><P>  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '22','nd ',</P><P></P><P></P><P>  IF(</P><P>  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),</P><P>  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '3' or</P><P>  LEFT(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),</P><P>  LEN(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'))-8) = '23','rd ','th ')))  </P><P>  &</P><P>  Mid(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),</P><P>  Index(Date(Date#(Replace(Replace(Replace(Replace(DateField,'th',''),'st',''),'rd',''),'nd',''),'DD MMM YYYY') + Date('20','DD'),'D MMM YYYY'),' ')+1)</P></BODY></HTML> Tue, 16 Sep 2014 13:40:36 GMT https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707110#M1063965 MK_QSL 2014-09-16T13:40:36Z Re: Making a new date from existing date https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707111#M1063968 <HTML><HEAD></HEAD><BODY><P>Thanks Marco.</P><P></P><P>Done.</P></BODY></HTML> Wed, 17 Sep 2014 04:40:58 GMT https://community.qlik.com/t5/QlikView/Making-a-new-date-from-existing-date/m-p/707111#M1063968 Anonymous 2014-09-17T04:40:58Z