Help with a formula - ELSE throws error 1

[cyreports]

I need to have this report "" as my value versus '0' as it is currently. I tried to add in an ELSE "" and it threw an error telling me a number was reqd. Not quite sure what I need to change this to.

If {Claims_txt.OrthodonticPlacementDate} <> #01/01/1800# and {Claims_txt.OrthodonticCompletionDate} <> #01/01/1800# then
DateDiff ("m",{Claims_txt.OrthodonticPlacementDate} ,{Claims_txt.OrthodonticCompletionDate} )

 

[Turkbear]

Hi,
All results from a formula must be of the same datatype, so your "" ( a string, albeit blank) is invalid, use 0 and conditionally supress the formula output display ( if you don't want to show the 0.)






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cyreports]

Thanks - great advice.

 

[Turkbear]

Glad to help...






To Paraphrase:"The Help you get is proportional to the Help you give.."