EntityConditions to lookup records between 2 dates

[Justin Robinson]

The following doesn't seem to work.

                 Calendar calS = Calendar.getInstance();
                 calS.set(Calendar.DAY_OF_MONTH, 25);
                 calS.set(Calendar.MONTH, (calS.get(Calendar.MONTH)-1));
                 Calendar calE = Calendar.getInstance();
                 calE.set(Calendar.DAY_OF_MONTH, 25);
                 Timestamp periodBeginning =
UtilDateTime.getTimestamp(calS.getTimeInMillis());
                 Timestamp periodEnd = 
UtilDateTime.getTimestamp(calE.getTimeInMillis());
                
                
                EntityCondition condition1 =
EntityCondition.makeCondition(EntityOperator.AND,
                                EntityCondition.makeCondition("invoiceTypeId",
EntityOperator.EQUALS, "SALES_INVOICE"),
                                EntityCondition.makeCondition("invoiceDate",
EntityOperator.LESS_THAN, periodEnd),
                                EntityCondition.makeCondition("invoiceDate",
EntityOperator.GREATER_THAN, periodBeginning));

This must be a fairly common task is there an EntityOperator for timestamps?

Thanks in advance.

-- 
Regards,
Justin
Venture-Net Research & Development