Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all
I have a requirement like below
| Date1 | Date2 |
| 6/2/2018 | 7/2/2019 |
| null | 7/25/2019 |
If the Date1 is null i need to populate the value from Date2 in the target
If the Date1 is not null i need to populate the value as current date in the target
My expected output column
| output |
| today's date (11/03/2019) |
| 7/25/2019 |
Thanks In Advance
Manish
Thanks @TRF
Am getting cannot convert string to date error, can you please help me out how to resolve it