Join Two Date Columns on Null Value

[LogMill1]

I have two data columns within the same table that I am attempting to join. When there is a date in the first column, the second column is null and vice versa.  Is there a way to join the columns together on the null values?

Example Table1:

ID	Date1	Date2
1	1/1/2023	(null)
2	1/2/2023	(null)
3	(null)	1/3/2023
4	1/4/2023	(null)
5	(null)	1/5/2023
6	(null)	1/6/2023
7	1/7/2023	(null)
8	(null)	1/8/2023

[Vijay_A_Verma · Accepted solution]

In a custom column put following

[Date1]??[Date2]