Null Date

[77walker]

I am running crystal xi and I have a datetime field that I have formatted to display only the year. I have some records that have a null date and I would like to display that group heading either as "YYYY" or show a string of "No Date". This is the formula I am trying to use:
if not isnull({incident.alarmdate}) then Year ({incident.alarmdate}) else "No Date"
I get the following error: A number is required at "No Date".

Can someone tell me what I am doing wrong with this formula?

 

[IanWaterman]

YOu can not have mixed data types in an If.. then ..else

Try

if not isnull({incident.alarmdate}) then totext(Year ({incident.alarmdate}),0,"") else "No Date"

Ian