saved search formula question: How do you use MONT...
# generald
Dani
09/01/2022, 3:31 PMsaved search formula question: How do you use MONTHS_BETWEEN? I can't find documentation but I want the months between a start date and end date
a
Adam McKeague
09/01/2022, 3:45 PM Copy code
something like this could work for you…
formula(numeric)
ABS(TO_DATE({field id for end date})-TO_DATE({field id for start date}))d
Dani
09/01/2022, 3:48 PM@Adam McKeague wouldn't that just give me days between? I want the number in months (like 2 months between jan 1 and feb 28)
a
Adam McKeague
09/01/2022, 3:56 PMI don't know how I breezed right past that part of your question. I clearly only paid attention to "between a start date and end date" - whoops.
MONTHS_BETWEEN(field id for date,{field id for other date})
no clue which one you should put first. but your results should tell you. Haha