Try:

IIF (DTOS({criminal_complaint.tarrestdatetime}) ;
        =="19000101","__________" ,'hello')

>OK,
>
>The date in the SQL field is 1/1/1900. If I put in the following code, I get a response of 'hello':
>
>IIF (date({criminal_complaint.tarrestdatetime})=date(1/1/1900),"__________" ,'hello')
>
>
>If I put in this code, I get 1/1/1900.
>
>IIF (date({criminal_complaint.tarrestdatetime})=date(1/1/1900),"__________" ,totext(date({criminal_complaint.tarrestdatetime}))
>
>
>Anyone have an idea how to get this IIF() to work properly?
>
>Thanks,
>
>
>>Hello,
>>
>>I have a datetime field in a SQL database. If that datetime field has the SQL default of 01/01/1900 as the value, I want the Crystal report to display "__________." If that datetime field has a value other than the SQL default, I want the date to display.
>>
>>How do I code this in Crystal 9?
>>
>>Thanks,
>>
>>TFISHER