Another URGENT HELP: what's the syntax for empty in Crystal Report?

[sommererdbeere]

hi,


this is extremely urgent. in Crystal report, i had a formula where i want to retrieve all the date where count_date field is empty. below is the code i wrote,

if {?count_date} = "" then {?count_date}

however, it keeps highlight ("&quot and asking me about date for ("&quot.. what does it mean?? is there any other way i can ask to get all date where the field is empty??

many many many thanks.. tahnk u thank u..

m

 

[Madawc]

I'm not clear what you're after, but try something like
if isnull({?count_date}) then "No Date"
else Totext({?count_date}, "dd MMM yy&quot

This assumes Crystal 8.5, it varies between version.

Madawc Williams
East Anglia, Great Britain