Need Impromptu solution to extract yesterday's data

[DMBFan]

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.

 

[GJParker]

You could try using the add-days() function

Date Field = add-days(Today(), -1)

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[DMBFan]

Thanks for the tip. I was able to figure the problem out by myself. As it turns out the problem stemmed from the 'today' function. The 'Date Field' used was a date-time field while the 'today' function is date only. Therefore I was trying to do an equal comparison of a date-time field with a date field. I simply added the function 'datetime-to-date' before the 'Date Field' and was able to get my result set.