Best way to add months (duration) to a date formula?

Question

Has anyone been able to establish the most elegant way of adding the duration in months to a date formula?

I know it's not straightforward because there are lots of variables in days in the month, and leap years etc. However, it would be great if someone has gone through this and was prepared to share their working?

[Date Agrmnt Signed] + [Agreement Duration (Months)]

Thanks.

archiveuser · Answer

Just to let you know, I've figured it outAdjustMonth([Date Agrmnt Signed], [Agreement Duration (Months)])

quickbasecoachd · Answer

Oh sorry. My mistake. The syntax isAdjustMonth([Start Date], [number of months])

quickbasecoachd · Answer

Yes. There is an elegant way [Date Agrmnt Signed] + Months([Agreement Duration (Months)])This presumes that the [Agreement Duration (Months)] field is numeric.

archiveuser · Answer

Unfortunately, that doesn't seem to be recognised, Mark.Formula error -- Unknown functionThe function name Months(number) is unknown.

nicolecordeiro · Answer

I'm having an issue as well, even using the formula above. I'm sure I'm doing something wrong. I have a date field called "hire date". I need another field to automatically add 6 months to the hire date and display it. This is the employees probation period. I want quickbase to automatically give me that date based on the "hire date". Help :(

Forum Discussion

Best way to add months (duration) to a date formula?

Related Content

Create a formula duration over 5 years

Duration Formula

Formula Checkbox and Duration

Duration Fields with Pipelines

Delete Formula Button Error