I want to find the Cancellation Deadline as a Date using a Formula Date field.
I have a [Start Date] field and
[Cancellation Notice] field of type Duration but I can change it to Numeric or text.
IF a class Starts on 1162015 and the class has a 10 day Cancellation Notice prior to that Start Date, what would that formula look like.
 0 Points
Posted 3 years ago
QuickBaseCoach App Dev./Training, Champion
 62,316 Points
I suggest making the cancellation notice field be a numeric field.
Then the formula for [Cancelation Date] would be
[Start Date]  Days([Cancellation Notice])
Then the formula for [Cancelation Date] would be
[Start Date]  Days([Cancellation Notice])
 0 Points
Since my policy is "business days" or essentially the work week, can i somehow utillize the workdays function to account for the weekends?
 0 Points
working on this further:
WeekdayAdd([Start Date], [Cancellation Notice]) validates but doesnt compute correctly.
Only when I do this:
WeekdayAdd([Start Date], 10) does it compute correctly
Obviously, I want it to pull from the field.which is numeric....
Thanks for your help.
WeekdayAdd([Start Date], [Cancellation Notice]) validates but doesnt compute correctly.
Only when I do this:
WeekdayAdd([Start Date], 10) does it compute correctly
Obviously, I want it to pull from the field.which is numeric....
Thanks for your help.
QuickBaseCoach App Dev./Training, Champion
 62,316 Points
WeekdayAdd([Start Date], [Cancellation Notice]) should work correctly if you have set the [Cancellation days] to be type numeric. When you say it does not compute correctly, what do you mean by that? Are you saying. a syntax error or the math calculation is not correct.
 0 Points
[Cancellation Notice] is a numeric Lookup Field from an other table. Does that matter? Right now it just returns a date that is not calculated correctly.
QuickBaseCoach App Dev./Training, Champion
 62,316 Points
For an example record, can you tell me the Start Date, the Cancellation Notice, the formula result and the answer you were wanting?
 0 Points
Strangely it is now working. Thanks for your help. Your questions back to me helped me think this through better.
QuickBaseCoach App Dev./Training, Champion
 62,316 Points
Related Categories

Formulas & functions
 2881 Conversations
 71 Followers

Tables & fields
 7159 Conversations
 170 Followers