Forum Discussion
ShaneMiller1
3 years agoQrew Cadet
I should also mention the Field Label and Type:
Date created: Date/ Time
Static date AKA effective contract date: Date
------------------------------
Shane Miller
------------------------------
Date created: Date/ Time
Static date AKA effective contract date: Date
------------------------------
Shane Miller
------------------------------
MarkShnier__You
3 years agoQrew Legend
I'm not sure of the answer yet, but let's see if we can boil down the question to fewer words.
Calculate the next quarterly date greater than or equal to [Date Created] based on a repeating cycle of quarterly dates based on the [Effective Contract date].
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Calculate the next quarterly date greater than or equal to [Date Created] based on a repeating cycle of quarterly dates based on the [Effective Contract date].
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- ShaneMiller13 years agoQrew CadetYes! I am 99% sure that is the question we are trying to solve for! Looking forward to your answer!
------------------------------
Shane Miller
------------------------------- MarkShnier__You3 years agoQrew LegendOK, try this. add as many Q's as you might ever need.
var date DateCreated = ToDate([Date Created]);
var date QZero = AdjustMonth([Contract Effective Date],0);
var date QOne = AdjustMonth([Contract Effective Date],3);
var date QTwo = AdjustMonth([Contract Effective Date],6);
var date QThree = AdjustMonth([Contract Effective Date],9);
var date QFour = AdjustMonth([Contract Effective Date],12);
var date QFive = AdjustMonth([Contract Effective Date],15);
Min(
If($QZero >= $DateCreated, $QZero),
If($QOne >= $DateCreated, $QOne),
If($QTwo >= $DateCreated, $QTwo),
If($QThree>= $DateCreated, $QThree),
If($QFour >= $DateCreated, $QFour),
If($QFive >= $DateCreated, $QFive))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- ShaneMiller13 years agoQrew CadetThis is awesome! I high hopes this will work.
I am getting an error for the line:
Min(
*expecting text but found date*
any ideas on how to fix?
------------------------------
Shane Miller
------------------------------