thank you. my problem was that I was doing the date replacement at the database level and that's why it wasn't working properly. when I followed your instructions and did the date on the report level then it worked.

thanks again