Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java
===================================================================
diff -u -r14667 -r14713
--- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java	(.../JasperreportsAction.java)	(revision 14667)
+++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/action/JasperreportsAction.java	(.../JasperreportsAction.java)	(revision 14713)
@@ -2184,7 +2184,7 @@
 		  				+" ti.locationForDisplay,ti.sterileEndTime,ti.sterilizationUser"
 		  				+" order by ti.sterileEndTime desc";
 		if (StringUtils.isNotBlank(startDate) && StringUtils.isNotBlank(endDate)) {
-			sql += " where ti.sterileEndTime between "
+			sql += " where " + dateQueryAdapter.stringFieldToDate("ti.sterileEndTime") + " between "
 						+ dateQueryAdapter.dateAdapter(startDate+" 00:00:00")
 						+ " and " + ""
 						+ dateQueryAdapter.dateAdapter(endDate+" 23:59:59");