Need to Add a condition to this formula

Question

Hi,I have my formula, but i need to add a condition to it
LastDayOfMonth(AdjustMonth([Start Date], ToNumber([Months Needed])))

If Employment Status is FTE add 5 years to the start date (and use the last day of the month), otherwise use the formula above.

How do I add that condition?

Thank You!

markshnier__you · Answer

Here is&nbsp; is one solution.

var date AdjustedStartDate = IF([Employment Status]="FTE", AdjustYear([Start date],5), [Start Date]);

LastDayOfMonth(AdjustMonth($AdjustedStartDate, ToNumber([Months Needed])))------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

reneehansen1 · Answer

it's perfect, thank you so much!------------------------------Renee Hansen------------------------------

Forum Discussion

Need to Add a condition to this formula