Table - Filter by dates

I am using filter criteria for some string fields and it works great. How do I implement the criteria for dates? It seems that if I format the dates to below format I get some dates back, but not all that I expect.

Can someone point me to a right direction for using filters on tables for dates?

Below are some relevant lines from my code:

fDate = calStartDate.getSelectedDate();

lDate = calEndDate.getSelectedDate();

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");

fsDate = formatter.format(fDate);

flDate = formatter.format(lDate);

criteria1 = new CompareFilterCriteria(new FieldKey("messages.msgReceiveTime"), fsDate,false,false,true);

criteria1 = new CompareFilterCriteria(new FieldKey("messages.msgReceiveTime"), flDate,true,false,false);

getTableRowGroup1().getTableDataFilter().setFilterCriteria(fCreteria);

[911 byte] By [vcollaka] at [2007-11-26 22:09:21]