troubleshooting Question

Highlight Formula for Empty Date Fields Older Than 5 Days Today

Avatar of Joseph LaFlex
Joseph LaFlexFlag for United States of America asked on
Crystal Reports
12 Comments1 Solution101 ViewsLast Modified:
I must be missing something in my logic that I don't see and need help.  I am writing a highlighting formula on a date field.  There are two dates involved.  

DateOne = in our system
DateTwo = left our system

The formula looks at DateTwo to see if there is a date there.  If there is no date there, and it has been in our system for more than 5 days it should highlight red on the empty field.

I can get it to work if I check for the date field being empty only.  However, if I check to see if the field is empty and it's been here for more than 5 days, nothing gets highlighted.

Here's my formula:



If isNull({DateTwo}) and ({DateOne} < DateAdd("d",-5, CurrentDate)) Then "X"

Can anyone see the logic I am missing?

Crystal Reports XI

Thanks

Joe
ASKER CERTIFIED SOLUTION
Joseph LaFlex
IT Technician

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros