Formula returns dummy date when there should be a null or blank value

[Devaki]

I had written a formula as below in Crystal reports 8.5

if <condition> then EndDate
else
DateTime(0,0,0,0,0,0)


Instead of returning a blank or null date it returns 12:00:00AM
How do i make it return a blank or null value ?
I also gave Date(0,0,0) but still it prints 12:00:00

Help Appreciated

Thanks
Dp

 

[kenhamady]

It is pretty difficult to have a formula return a null. It will return the default value for that data type, which isn't null. There is no &quot;Blank&quot; date.

You can simply suppress the field when it is equal to that value.

Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Devaki]

Thanks ken
It works fine after suppress