if statement for datetime 1

[grom71]

Hi,
I think this is a simple one, but my brain is dead this morning.
I have a date/time field called {DIAGNOSI.END_DATE}

I need an IF statment to say is the date is = 01/01/1900 then "" else {DIAGNOSI.END_DATE}. The rougue date needs stripping out...to give a blank field.

I can't even get this basic of statements to work !

Please help me !
Steve

Authorised re-seller of CRD (a powerful scheduling tool for automating Crystal reports)
Visit

http://www.reports-for-healthcare.com

for 10% discount.

 

[smcnulty2000]

You are dealing with two data types.

If you are just working on suppressing it in the canvas you can go to the conditional formatting and suppress using

currentfieldvalue=#1/1/1900#

That's a right-click on the formula on the canvas, then select 'format field', 'common', and the x-2 next to suppress. I include all that just in case.

Otherwise you have to convert the date to a text using totext.

if {DIAGNOSI.END_DATE}= #01/01/1900# then "" else totext({DIAGNOSI.END_DATE},"MM/dd/yyyy").

Good luck with the brain-dead thing. Been there.

 

[grom71]

Went for the latter option thanks...
My brain is starting to wake up now.. enjoy your weekend
Steve

Authorised re-seller of CRD (a powerful scheduling tool for automating Crystal reports)
Visit

http://www.reports-for-healthcare.com

for 10% discount.