If date is default date convert to text

[niteraven]

Hi

I am new to Crystal Reports. I am wondering if the following is possible (i do it all the time in MS Access)

On a report i want to check to see if the default date is 1/1/1900 if it is on the report i want it to show as "None".

I have tried different IIF statements i do not believe this function will work because if it has a legitimate date (not the default 1/1/1900) then i want that to print out.

I have tried if then else statements and they are not working either.

Any help or direction is greatly appreciated!
Raven

 

[kray4660]

I have done something like this in the past. This assumes that {Date_Field} is a date field not a date-time field.
If {Date_Field} = Date(1900,1,1) then "None" else totext({Date_Field})