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?
Explore Alt function.
use alt function.
the alt function was the trick,
thanks a lot for really quick answer.
Suppose every date field has 6 digits, then you can try this expression: Left(date1 & date2 & date3, 6)
works in my testcase but that is not a stable solution.
Retrieving data ...