Choosing 1 date from 3 different date fields 1

[BJD]

I have 3 date fields, each from a different table, and would like to use a formula that shows only one date based on the following conditions:

If cld_desired_ship_date is null, return cl_desired_ship_date, but if cl_desired_ship_date is null, return co_desired_ship_date.

The table (CLD) containing cld_desired_ship_date is joined with a left outer join - not every record in the 2 other tables (CL and CO) has an entry in the CLD table.

 

[kenhamady]

I assume that you can get all three dates into one record, without duplication. If so, try this:

If IsNull(CLD) and IsNull(CL) then CO else
If IsNull(CLD) then CL else
CLD Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/