topic Compare two dates in QlikView https://community.qlik.com/t5/QlikView/Compare-two-dates/m-p/885196#M308702 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Promised Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Actual Date</STRONG></TH></TR><TR><TD style="padding: 2px;">01/01/2015</TD><TD style="padding: 2px;">03/01/2015</TD></TR><TR><TD>23/01/2015</TD><TD>20/01/2015</TD></TR><TR><TD>23/01/2015</TD><TD>23/01/2015</TD></TR></TBODY></TABLE><P></P><P>Hi I want to make a new field say XYZ,</P><P>I want XYZ to be 1 id Actual Date is equal or less than promised date.</P><P>XYZ should be 0 otherwise.</P><P></P><P></P><P>How can I achieve this?</P><P>Please help.</P><P></P><P>Thanks</P><P>Arjun Jain</P></BODY></HTML> Thu, 09 Apr 2015 11:50:22 GMT 2015-04-09T11:50:22Z Compare two dates https://community.qlik.com/t5/QlikView/Compare-two-dates/m-p/885196#M308702 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Promised Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Actual Date</STRONG></TH></TR><TR><TD style="padding: 2px;">01/01/2015</TD><TD style="padding: 2px;">03/01/2015</TD></TR><TR><TD>23/01/2015</TD><TD>20/01/2015</TD></TR><TR><TD>23/01/2015</TD><TD>23/01/2015</TD></TR></TBODY></TABLE><P></P><P>Hi I want to make a new field say XYZ,</P><P>I want XYZ to be 1 id Actual Date is equal or less than promised date.</P><P>XYZ should be 0 otherwise.</P><P></P><P></P><P>How can I achieve this?</P><P>Please help.</P><P></P><P>Thanks</P><P>Arjun Jain</P></BODY></HTML> Thu, 09 Apr 2015 11:50:22 GMT https://community.qlik.com/t5/QlikView/Compare-two-dates/m-p/885196#M308702 2015-04-09T11:50:22Z Re: Compare two dates https://community.qlik.com/t5/QlikView/Compare-two-dates/m-p/885197#M308703 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Both field in same table then</P><P></P><P></P><P>write in script</P><P></P><P>if(ActualDate&lt;=PromisedDate,1,0) as Flag</P><P></P><P>Regards</P></BODY></HTML> Thu, 09 Apr 2015 11:58:49 GMT https://community.qlik.com/t5/QlikView/Compare-two-dates/m-p/885197#M308703 PrashantSangle 2015-04-09T11:58:49Z Re: Compare two dates https://community.qlik.com/t5/QlikView/Compare-two-dates/m-p/885198#M308704 <HTML><HEAD></HEAD><BODY><P>if(Actual Date&lt;= Promised Day,1,0) as XYZ</P></BODY></HTML> Thu, 09 Apr 2015 11:58:53 GMT https://community.qlik.com/t5/QlikView/Compare-two-dates/m-p/885198#M308704 robert_mika 2015-04-09T11:58:53Z Re: Compare two dates https://community.qlik.com/t5/QlikView/Compare-two-dates/m-p/885199#M308705 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>t1</P><P>Load </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">&nbsp;&nbsp;&nbsp;&nbsp; [Promised Date],</SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Actual Date],</P><P>&nbsp;&nbsp;&nbsp;&nbsp; if( <SPAN style="font-size: 13.3333330154419px;">[Actual Date]&lt;=<SPAN style="font-size: 13.3333330154419px;">[Promised Date],1,0)&nbsp;&nbsp;&nbsp;&nbsp; as XYZ</SPAN></SPAN></P><P>Resident</P><P>&nbsp;&nbsp;&nbsp;&nbsp; YourTable;</P><P></P><P>drop Table <SPAN style="font-size: 13.3333330154419px;">YourTable;</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">rename table T1 to <SPAN style="font-size: 13.3333330154419px;">YourTable;</SPAN></SPAN></P></BODY></HTML> Thu, 09 Apr 2015 11:59:33 GMT https://community.qlik.com/t5/QlikView/Compare-two-dates/m-p/885199#M308705 pokassov 2015-04-09T11:59:33Z