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