=== modified file 'dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java' --- dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java 2012-06-28 06:28:55 +0000 +++ dhis-2/dhis-services/dhis-service-patient/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java 2012-07-02 10:42:51 +0000 @@ -322,7 +322,7 @@ String eDate = DateUtils.getMediumDateString( endDate ); sql += "and psi.executiondate >= '" + sDate + "' "; - sql += "and psi.executiondate < '" + eDate + "' "; + sql += "and psi.executiondate <= '" + eDate + "' "; } if ( orgUnits != null )