Skip to Content

Is it possible to use Input Parameter in ADDMONTHS ( ) function in a calculated column?

Hi Experts,

Addmonths ( ) function is perfectly worked for columns.



But It wont work when I use Input Parameters inside that function.



when I use the above expression it throws an error like as invalid Expression.

Input Parameter Datatype is Date.

And,I also tried with the integer Datatype., It won't works.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 02, 2018 at 01:53 PM

    For the column engine no such function exists. In the SQL engine the function is called ADD_MONTHS (not ADDMONTHS). Using it in an SQL engine calculated column, when putting the parameter name in single quotes works quite will (if a syntax validation error occurs, just ignore it).

    ADD_MONTHS('$$IP_DATE$$', 2)


    Add comment
    10|10000 characters needed characters exceeded