Definition
The COALESCE() function returns the first non-null value in a list.
Syntax
COALESCE(value_1, value_2, ...., value_n)
where value_1, value_2, ...., value_n are required parameters and are the values to test.
Example(s)
What to use in Custom SQL field:
COALESCE([Assignment: Actual End Date], [Assignment: Extended End Date], [Assignment: Scheduled End Date])
Field Outputs:
CONVERT(VARCHAR, COALESCE([Assignment: Actual End Date], [Assignment: Scheduled End Date]), 101)
Field Outputs:
