Need to Add a condition to this formula
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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHere is 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
------------------------------
it's perfect, thank you so much!
------------------------------
Renee Hansen
------------------------------
