Thanks Mike, I will give it a try.
TFISHER
>Try:
>IIF (DTOS({criminal_complaint.tarrestdatetime}) ;
> ==š**000101","__________" ,'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
Thanks,
TFISHER