topic operation with date in QlikView https://community.qlik.com/t5/QlikView/operation-with-date/m-p/178302#M45544 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Your formulae shoud be like below.</P><P>=date(date#('4/8/2009','DD/MM/YYYY')+10,'DD-MM-YYYY')</P><P style="font-weight: bold">o/p - 14/8/2009</P><P><B>- Sridhar</B><IMG alt="Yes" src="http://community.qlik.com/emoticons/emotion-21.gif" /></P><P></P></BODY></HTML> Tue, 08 Sep 2009 16:32:10 GMT 2009-09-08T16:32:10Z operation with date https://community.qlik.com/t5/QlikView/operation-with-date/m-p/178300#M45542 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>please I would to add a day from a date :</P><P>for example: 01/01/2009+ 100 days ..</P><P>How to?</P><P>Thanks</P><P>Best Regards</P><P>Sl</P></BODY></HTML> Tue, 08 Sep 2009 16:20:49 GMT https://community.qlik.com/t5/QlikView/operation-with-date/m-p/178300#M45542 2009-09-08T16:20:49Z operation with date https://community.qlik.com/t5/QlikView/operation-with-date/m-p/178301#M45543 <HTML><HEAD></HEAD><BODY><P></P><P>=</P><P>date((invoice_date)+100)</P><P>or</P><BR /><BR /> <P></P><P></P><P>=</P><P>date((01/01/2009)+ 100)</P><BR /><BR /> <BR /><BR /></BODY></HTML> Tue, 08 Sep 2009 16:27:21 GMT https://community.qlik.com/t5/QlikView/operation-with-date/m-p/178301#M45543 2009-09-08T16:27:21Z operation with date https://community.qlik.com/t5/QlikView/operation-with-date/m-p/178302#M45544 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Your formulae shoud be like below.</P><P>=date(date#('4/8/2009','DD/MM/YYYY')+10,'DD-MM-YYYY')</P><P style="font-weight: bold">o/p - 14/8/2009</P><P><B>- Sridhar</B><IMG alt="Yes" src="http://community.qlik.com/emoticons/emotion-21.gif" /></P><P></P></BODY></HTML> Tue, 08 Sep 2009 16:32:10 GMT https://community.qlik.com/t5/QlikView/operation-with-date/m-p/178302#M45544 2009-09-08T16:32:10Z