Thanks for replying but I finally figured out what the problem was. Crystal Reports actually cares what order you put your select expression formula in. I moved the isnull({viewRequests.Date}) to be the first condition and the parm check the second and it now works fine.