Hello:
I have a date column field in my report that when null is '1/1/1970 12:00:00.000000 AM'. I don't want this null data to be displayed, but I do want to display all other dates. I have been trying to set up an expression for this field that will only show the result if the value doesn't match null. Yet, I constantly get errors with the comparison. Is what I'm trying to do possible? I would greatly appreciate any help in solving, what should be, a simple problem.
Thanks,
Brian
I was able to figure this one out... I had to make sure that I was comparing the right kind of datatypes. Also, in the ELSE portion of my IF statement, I had changed it to NULL instead of ('') and it worked. I guess it was expecting a date when I was passing a string.
Thank you