Invalid Data in Date Field - Crystal Reports

[kshoemate]

I am writing a report using a large database and one of the fields I need to use is a date field which may or may not be null. My problem is occasionally a field looks empty, but does not evaluate as null. Instead Crystal Reports errors. If I go to the field on the datascreen and put a date in and then delete it the field is fine. Is there any way to trap a record that is not null but has some sort of invalid characters in it? I have tried evaluating with ISDATE but it doesn't seem to work.

 

[Turkbear]

Hi,
Which database? Does the Field Explorer show it as a true DATE type, or is it just a text field with date-type data?




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

 

[Madawc]

Is the field text? If so, use NumericText to check if it can be treated as a date.

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