Skip to main content
Azeglio Martinelli が「#Analytics」で質問

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.

2 件の回答
  1. 2024年6月10日 13:07

    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.

0/9000