Isnull Date field then Blank spaces

[cunner26]

Hello,

I am working on a report that requires me to have the date appear in a certain format, for instance (YYYYMMDD). When I take the date field and use the following

cdate(Field)

then the date appears in the correct format. The problem I am running into is that if there is no date in the field then I need 8 blank spaces. I have tried using the following formula,

if isnull({eeCustomData.Field2}) then " " else cdate({eeCustomData.Field2})

An error message returns stating "a string is required here" and places the cursor infront of the cdate statement.

Any help on this would be much appreciated,

P.S. eeCustomData.Field2 has been set up as a date field.

 

[synapsevampire]

Use another field over the top of it and conditionally suppress each based on the ISNULL({date})

-k

 

[synapsevampire]

Sorry, in a hurry, that's a formula field over the top of it, and it contains " "

Suppress it with not(isnull({eeCustomData.Field2}))

and your table field suppression is:

isnull({eeCustomData.Field2})

-k