Tampapat
asked on
IF THEN Statement not working
My statement seems to throw an error that a Date Is Required Here and I do not know what is wrong.
Crystal Reports 2008
if {EMPLOYEE.TERM_DATE} = 01/01/1800 then "NA" Else {EMPLOYEE.TERM_DATE}
Crystal Reports 2008
if {EMPLOYEE.TERM_DATE} = 01/01/1800 then "NA" Else {EMPLOYEE.TERM_DATE}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try
if {EMPLOYEE.TERM_DATE} = #01/01/1800# then "NA" Else {EMPLOYEE.TERM_DATE}