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