Hi,
My workflow includes calculating the time to maturity of capital instruments, however some instruments are perpetual (i.e. no maturity date). The preference would be to show the word "Perpetual", however t
The days to maturity column has been classed as a "Date" data type.
Thanks
Solved! Go to Solution.
You can convert date to string in the select tool and add the words.
Or treat the date column as string from the beginning itself.
Date function will still work on string columns provided its in format yyyy-mm-dd. And you can replace Null()'s will word "Perpetual"
Hope this helps 🙂
Very helpful indeed!
Happy to help 🙂 @wikus_struwig
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂