Perpetual maturity date in "Date" field

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

Workflow

Date Time

Accepted answers

Hi @wikus_struwig

Here is a supporting workflow

Input: data metainfo

Workflow:

Hope this helps 🙂

All comments

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 🙂

Hi @wikus_struwig

Here is a supporting workflow

Input: data metainfo

Workflow:

Hope this helps 🙂

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15875

MarqueeCrew 13708

apathetichell 13703