Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoActually this one is probably better to use.
var date SD=[MY Date Field];
var date ED=Today();
(Year($ED)-Year($SD)-1)*12 // start off with 12 times the number of fully completed years
+If(Month($ED)>=Month($SD),12,0) //add 12 months if the last year was fully completed
+ If((Month($ED)>=Month($SD)),Month($ED)-Month($SD),12+Month($ED)-Month($SD)) // add the number of months between the month numbers.
-If(Day($ED)<Day($SD),1,0) // but if the day did not catch up to the start date's day number, then subtract 1.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
var date SD=[MY Date Field];
var date ED=Today();
(Year($ED)-Year($SD)-1)*12 // start off with 12 times the number of fully completed years
+If(Month($ED)>=Month($SD),12,0) //add 12 months if the last year was fully completed
+ If((Month($ED)>=Month($SD)),Month($ED)-Month($SD),12+Month($ED)-Month($SD)) // add the number of months between the month numbers.
-If(Day($ED)<Day($SD),1,0) // but if the day did not catch up to the start date's day number, then subtract 1.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
ChristopherAngu
3 years agoQrew Member
That worked perfectly!! Thank you so much for your help Mark it is much appreciated.
------------------------------
Christopher Angulo
------------------------------
------------------------------
Christopher Angulo
------------------------------
Related Content
- 4 months ago
- 2 months ago
- 10 months ago