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

Crystal Reports

Avatar of undefined
Last Comment
Scott Johnston

8/22/2022 - Mon
Mike McCracken

Is the field a DATE or DATETIME field?

Is it perhaps a STRING that looks like a date.

Scott Johnston

yes it is  Date field, in a flat file.


Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Scott Johnston

I have tried for 2 days, this worked.  Thank you
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.