Beast Mode Syntax

Options
damen
damen Contributor

Hi,

I am trying to create a column that shows the year that a financial instrument was created and then I need to add 3 to it. It is going on the bottom of the x-axis so it will show up like '2022-2025' , '2023-2026', '2024-2027', etc.

The problem when I go to write the beast mode below is that it thinks it is a math function. How do I change to a string in beast mode?

Thanks!

If this helps, feel free to agree, accept or awesome it!

Tagged:

Answers

  • david_cunningham
    Options

    @damen

    wrap it in CONCAT() and then adjust your year

    Concat(year(date issued), ‘-‘, year(date_add(date issued, interval 3 year)))

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**

  • damen
    damen Contributor
    Options

    @david_cunningham that just gave me a bunch of 0's

    If this helps, feel free to agree, accept or awesome it!

  • david_cunningham
    Options

    @damen please post the code you are using.

    David Cunningham

    ** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
    ** Did this solve your problem? Accept it as a solution! ✔️**