Version 8.0 - How do you compare date fields to one-another

[mrspecial]

I have 5 different fields that are datetime type. I need to compare each one in a formula. For example if 4 out of 5 are NULL i want the report to return the non-NULL date, or if i have 3-Nulls and 2 dates. I then want to compare the 2 and find the later date of the 2 and return this on the report. Please HELP ASAP ,,,,..........thanks

 

[kenhamady]

In other words you want the highest of the 5 dates, excluding nulls?

First write a formula for each date:

if IsNull({date})
then Date(1,1,1)
else {date}

Then to find the latest use:

Maximum( [{@date1},{@date2},{@date3},{@date4},{@date5}] ) Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/