Suppress Datetime '1/1/1900 12:00:00.000 AM'

[fredong]

I am using CR v.8.0 and I tried to suppress a date field on the Detail section it did not work and it is still showing the same value.Below is my syntax to suppress on the field. Please advise. Thanks.


toText({ABCDSP;1.Date}) = '1/1/1900 12:00:00.000 AM'

 

[synapsevampire]

Try:

{ABCDSP;1.Date} = cdatetime(1900,1,1,0,0,0)

I don't have Crystal in front of me, so you might need to adjust the hour as I can't recall how Crystal treats midnight.

-k

 

[fredong]

I have resolved my own problem by go to File and Report option and changed from Datetime to Date. Follow by I create a formula below and put in the detail section.


if totext({ABCDSP;1.Date})'1/1/1900' then ''
else totext({ABCDSP;1.Date})



Anyway. Thanks for your help/