Fixed bug 23506 start date from and the end date from should be consider as equal
authorSandra Huguet <sandra.huguet@openbravo.com>
Mon, 27 May 2013 15:40:47 +0200
changeset 20473 ee752250a37d
parent 20472 d8cc7de67a13
child 20474 bb419c9b4257
Fixed bug 23506 start date from and the end date from should be consider as equal
src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR_data.xsql	Mon May 27 19:16:03 2013 +0530
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR_data.xsql	Mon May 27 15:40:47 2013 +0200
@@ -12,7 +12,7 @@
  * under the License. 
  * The Original Code is Openbravo ERP. 
  * The Initial Developer of the Original Code is Openbravo SLU 
- * All portions are Copyright (C) 2001-2010 Openbravo SLU 
+ * All portions are Copyright (C) 2001-2013 Openbravo SLU 
  * All Rights Reserved. 
  * Contributor(s):  ______________________________________.
  ************************************************************************
@@ -59,9 +59,9 @@
     <Parameter name="language"/>
     <Parameter name="adUserClient" type="replace" optional="true" after="AND wr.AD_CLIENT_ID IN (" text="'1'"/>
     <Parameter name="adUserOrg" type="replace" optional="true" after="AND wr.AD_ORG_ID IN (" text="'1'"/>
-    <Parameter name="parStartDateFrom" optional="true" after="AND 1=1"><![CDATA[AND wr.STARTDATE > TO_DATE(?)]]></Parameter>
+    <Parameter name="parStartDateFrom" optional="true" after="AND 1=1"><![CDATA[AND wr.STARTDATE >= TO_DATE(?)]]></Parameter>
     <Parameter name="parStartDateTo" optional="true" after="AND 1=1"><![CDATA[AND wr.STARTDATE < TO_DATE(?)+1]]></Parameter>
-    <Parameter name="parEndDateFrom" optional="true" after="AND 1=1"><![CDATA[AND wr.ENDDATE > TO_DATE(?)]]></Parameter>
+    <Parameter name="parEndDateFrom" optional="true" after="AND 1=1"><![CDATA[AND wr.ENDDATE >= TO_DATE(?)]]></Parameter>
     <Parameter name="parEndDateTo" optional="true" after="AND 1=1"><![CDATA[AND wr.ENDDATE < TO_DATE(?)+1]]></Parameter>
     <Parameter name="parProcessPlan" optional="true" after="AND 1=1"><![CDATA[AND pp.MA_ProcessPlan_id =?]]></Parameter>
   </SqlMethod>