Link to home
Start Free TrialLog in
Avatar of Scott Johnston
Scott JohnstonFlag for United States of America

asked on

Date Is required Crystal Reports Error

I am trying to find record in a MAS200 database that have a field that is a date field.  When I look up date it works fine, when I try to look up record that does not have any data in this field ( Ithin it would be null) I keep getting "Date is required)
{AR1_CustomerMaster.DateLastActivity} = date(0,0,0)

this is the format I tried in crytal reports.  Can anyone advise?

Crystal 8.5
Database is MAS200  3.71

Avatar of Mike McCracken
Mike McCracken

Is the field a DATE or DATETIME field?

Is it perhaps a STRING that looks like a date.

Avatar of Scott Johnston


yes it is  Date field, in a flat file.

Avatar of dougvarga
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I have tried for 2 days, this worked.  Thank you