Bug 203680 Birt Designer "date" and "time" filter doesn't work properly
Comment from Gauri 1. the filter for date and time in designer doesnt work correctly. I tried to filter on any date column having time NOT equal to 12:00:00. On the UI, the date is shown as say Sept. 4, 1995, but internally actual date value has time 2:45 am. Now if I try to apply a filter say <expression name="expr">row["Column Binding"]</expression> <simple-property-list name="value1"> <value>"1995-09-04"</value> </simple-property-list> filter returns blank resultset. So the time value is not getting ignored. Similarly filter on another time column like given below also doesnt work. <expression name="expr">row["Column Binding1"]</expression> <simple-property-list name="value1"> <value>"14:00:00"</value> </simple-property-list> 2. Open DateAndTimeReport.rptdesign and apply filter on "date-time" column having time Not equal to 12:00:00 also doesnt work. Needs engine side investigation on this.
core/org.eclipse.birt.core/src/org/eclipse/birt/core/data/DataTypeUtil.java
* A temp solution to the adoption of ICU4J in BIRT. It is a simple
	 * delegation to toDateWithCheck( String, Locale ).
	 * 
	 * @param source
	 * @param locale
	 * @return Date
	 * @throws BirtException
	 */
	public static Date toDateWithCheck( String source, Locale locale )
			throws BirtException
	{
		return toDateWithCheck( source, ULocale.forLocale( locale ) );
	}
	/**
	 * Convert string to date with check.
	 * JDK may do incorrect converse, for example:
	 * 		2005/1/1 Local.US, format pattern is MM/dd/YY.
	 * Above conversion can be done without error, but obviously
	 * the result is not right. This method will do such a simple check,
	 * in DateFormat.SHORT case instead of all cases.
	 * 		Year is not lower than 0.
	 * 		Month is from 1 to 12.
	 * 		Day is from 1 to 31.  
	 * @param source
	 * @param locale
	 * @return Date
	 * @throws BirtException
	 */
	public static Date toDateWithCheck( String source, ULocale locale )
			throws BirtException