topic Re: How to find a date ?? in QlikView https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437836#M488206 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use this expression:</P><P>=</P><P><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date#</SPAN><SPAN style="font-size: 8pt;">('01/01/2013','DD/MM/YYYY') + 10) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Niranjan M.</SPAN></P></BODY></HTML> Mon, 21 Jan 2013 07:33:38 GMT 2013-01-21T07:33:38Z How to find a date ?? https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437835#M488205 <HTML><HEAD></HEAD><BODY><P>How to find a date throgh expression</P><P></P><P>Date(17/09/2012) + 60 days = Result Date </P></BODY></HTML> Mon, 21 Jan 2013 07:25:08 GMT https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437835#M488205 2013-01-21T07:25:08Z Re: How to find a date ?? https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437836#M488206 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>use this expression:</P><P>=</P><P><SPAN style="color: #0000ff; font-size: 8pt;">Date</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Date#</SPAN><SPAN style="font-size: 8pt;">('01/01/2013','DD/MM/YYYY') + 10) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Niranjan M.</SPAN></P></BODY></HTML> Mon, 21 Jan 2013 07:33:38 GMT https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437836#M488206 2013-01-21T07:33:38Z Re: How to find a date ?? https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437837#M488207 <HTML><HEAD></HEAD><BODY><P>hi</P><P>see attachement</P><P>=Date(Date#('17/09/2012','DD/MM/YYYY') + 60)</P></BODY></HTML> Mon, 21 Jan 2013 08:48:16 GMT https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437837#M488207 2013-01-21T08:48:16Z Re: How to find a date ?? https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437838#M488208 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>=Date(Today() + 60)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 21 Jan 2013 08:53:06 GMT https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437838#M488208 jagan 2013-01-21T08:53:06Z Re: How to find a date ?? https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437839#M488209 <HTML><HEAD></HEAD><BODY><P>try this</P><P>Date(Date#(TempDate,'DD-MM-YYYY')+35)</P><P>here TempDate is my date field</P><P>you could also write today() replacing field and manually date also but in your date format ..</P><P>hope it helps</P></BODY></HTML> Mon, 21 Jan 2013 08:57:14 GMT https://community.qlik.com/t5/QlikView/How-to-find-a-date/m-p/437839#M488209 er_mohit 2013-01-21T08:57:14Z