Filter records for due date 1

[Freefall27]

I am running CR XI and need to filter records based on yesterday's date. I constructed formula CurrentDate - 1 and now need to only pull records with due date of yesterday.

Name Number Ref Due Date
Record 1 5679 11/25/2005
Record 2 6894 11/27/2005
Record 3 3695 11/25/2005

How can I filter to only show yesterday's due date (Record 2)

Newbie to Crystal Reports but learning a lot here.
Thanks for the help

 

[Freefall27]

Additionally I would only want to include Monday - Friday or only business days each week.

Thanks

 

[kskid]

Are you scheduling to run this Monday through Friday?

If so, add the following to the record selection formula

(
if DayofWeek({table.date}) = 2 then
{table.date} = currentdate - 3
else
{table.date} = currentdate - 1
)

-lw