SOLVED

Difficulty with calculated column

Copper Contributor

Hello,

I am having issues with a calculated column where I am trying to adjust a date based on a defined frequency.  I have a column set as a numerical value for number of months that I would like to add to a date but when I put the formula in my output is not what I would expect.  Below is an image of the columns I am using as well as my formula.  Thank you for any support. 2024-03-10_15h03_04.png2024-03-10_15h03_34.png

2 Replies
best response confirmed by RBourbon (Copper Contributor)
Solution

@RBourbon you + column needs to be outside the Month() function. 

@ChrisWebbTech Thanks for the help! Glad it was something but still do not understand how it was able to produce the same date and not throw an error.

1 best response

Accepted Solutions
best response confirmed by RBourbon (Copper Contributor)
Solution

@RBourbon you + column needs to be outside the Month() function. 

View solution in original post