The Formula I posted is fine, at least it works in Crystal 8.5 against the Northwind.Orders table (SQL Server).

Does the date portion of the formula work for you?

What I find curious is that there is no Where clause being generated by Crystal.