empty date field.

[3dthies]

I have wrote a formular:

if isnull ({PERSON.DATE}) then "bla" else
{PERSON.DATE}

CR told me that a string is rquired here (the second row of the formular)

I want to write a text if the date fiel is empty and if its not then print the date field

 

[Madawc]

Try

if isnull ({PERSON.DATE}) then "bla" else 
ToText({PERSON.DATE})

Any formula field can also be used as a display field, string or number or currency or date. In this case, it won't treat the date as a string unless you request this specifically using ToText.

ToText can also format dates, you might find this useful.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10