Is null handling with 3 dates

[stabben23]

Hi,

I have a problem: this is my table

This should be handled in this way, pseudocode:

if(isnull(date1),date2,date1) and if( isnull(date1 and date 2),date3) as Finaldate

I do this in the script, does anyone have a quick solution?

[#2]

Explore Alt function.

[#3 · Accepted solution]

use alt function.

[stabben23]

Hi Ramkumar,

the alt function was the trick,

thanks a lot for really quick answer.

[#5]

Suppose every date field has 6 digits, then you can try this expression: Left(date1 & date2 & date3, 6)

[stabben23]

works in my testcase but that is not a stable solution.