I am using the months_between date function to calculate the number of months between two dates in a CRMA recipe.
I am trying to use the roundOff parameter. However, I get only error messages when using the parameter.
So far I tried:
- roundOff(True)
- roundOff(true)
- roundOff=true
- roundOff=True
When I use the function without roundOff it calculates the months correctly. -> Meaning the dates I am using are in the correct format.
The documentation just states that roundOff is a boolean but now how to type it.
When I use the formula like this:
months_between(End_Date, Start_Date, roundOff=false)
I get this error:
Your formula uses a non-existent field. Update or remove the following fields: roundOff.
When I use the formula like this:
months_between(End_Date, Start_Date, roundOff(false))
I get this error:
Something is wrong with the function in row 1 and column 82. A parameter is missing or a field name is being used that is also a function name.
Thank you but I know what the parameter does, my question was about how to use it so that I do not get any error message in the recipe.