I have a problem with the filter statement we use to "look" at a previous days data. We had previously used the Impromptu filter "(Date Field) = today () - 001 00:00:00.0000". We started accessing data from a SQL 2000 database yesterday and it seems it doesn't like the "interval" portion of the expression. I could just schedule the report late at night and just use the today function but then we could run into problems with the "Entered Time" of our orders.