Scott Johnston
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.DateLa stActivity } = date(0,0,0)
this is the format I tried in crytal reports. Can anyone advise?
Crystal 8.5
Database is MAS200 3.71
Scott
{AR1_CustomerMaster.DateLa
this is the format I tried in crytal reports. Can anyone advise?
Crystal 8.5
Database is MAS200 3.71
Scott
ASKER
yes it is Date field, in a flat file.
Scott
Scott
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have tried for 2 days, this worked. Thank you
Is it perhaps a STRING that looks like a date.
mlmcc