Hi,
I'm new to this site, so please bear with me as I learn the "techspeak" and such! In my Crystal Report (2008 version), I've been asked to "hide", or just make blank, whenever a specific date appears in a column. The Date is 1/1/1700. I thought I could write the following If Then Else statement to hide it:
If{EMPLOYEE.TERM_DATE}=#1/1/1700# then "" else "{EMPLOYEE.TERM_DATE}"
However, I get an error message that says the 'else' section of this statement needs to be a string, and I get it, it's because the 'then' is also a string. So the challenge. What's the best way to essentially hide all dates that appear like 1/1/1700? I'm hoping this is an easy question for more advanced Crystal users. Thanks!
IP Logged
