Calculate date of previous day

[25456378]

Dear COGNOS users,

I would like to run a report daily at 00:05 AM to collect data generated on the previous day. I am using scheduler to run the report however I have a problem of how to set the date filter in the report. I need to collect data of the previous day and I am using the following synthax:

day(today())-1=day(Receive date)and month(today())=month(Receive date)and year(today())=year(Receive date)........

This works OK but fails if the day is the first of the month, since day(today())-1=day(Receive date) will return a 0 and so no data is retrieved.

Anyone can provide me with any suggestions? I am using COGNOS Impromptu version 7.5.

Thanks,
Ian