Forum Discussion
Solved
Join Two Date Columns on Null Value
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 |
In a custom column put following
[Date1]??[Date2]
1 Reply
In a custom column put following
[Date1]??[Date2]