Perpetual maturity date in "Date" field

[wikus_struwig]

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

[atcodedog05]

Hi @wikus_struwig 

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 🙂

[atcodedog05 · Accepted solution]

Hi @wikus_struwig 

Here is a supporting workflow

Input: data metainfo

Workflow:

Hope this helps 🙂

[wikus_struwig]

Very helpful indeed!

[atcodedog05]

Happy to help 🙂 @wikus_struwig 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂