Forum Discussion
BlakeHarrison
5 years agoQrew Captain
Unfortunately, there isn't a numeric field type that would produce Years, Months, and Days. You would probably need to either do 3 individual numeric formulas OR a single Text formula.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
MarkShnier__You
Qrew Legend
5 years agoThis formula will do years and months. But I or someone would need to get inspired to get the days working too.
var date MyDate = [My date];
var text Years = ToText(
Year(Today())-Year($MyDate)
-
If(
Month(Today())<Month($MyDate)
or
(Month(Today())=Month($MyDate) and Day(Today())<Day($MyDate)),1,0));
var text Months = If(
Month(Today()) > Month($MyDate), ToText(Month(Today()) - Month($mydate)),
Month(Today()) = Month($MyDate) and Day(Today()) > Day($Mydate), ToText(Month(Today()) - Month($mydate)),
Month(Today()) = Month($MyDate) and Day(Today()) < Day($Mydate), "11",
ToText(12-(Month($mydate) - Month(Today()))));
var text RawResult=
$Years & "yr" & If ($years <> "1","s") & " " & $Months & "mth" & If($Months<>"1","s");
If($years<>"" and $Months<>"", $RawResult)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var date MyDate = [My date];
var text Years = ToText(
Year(Today())-Year($MyDate)
-
If(
Month(Today())<Month($MyDate)
or
(Month(Today())=Month($MyDate) and Day(Today())<Day($MyDate)),1,0));
var text Months = If(
Month(Today()) > Month($MyDate), ToText(Month(Today()) - Month($mydate)),
Month(Today()) = Month($MyDate) and Day(Today()) > Day($Mydate), ToText(Month(Today()) - Month($mydate)),
Month(Today()) = Month($MyDate) and Day(Today()) < Day($Mydate), "11",
ToText(12-(Month($mydate) - Month(Today()))));
var text RawResult=
$Years & "yr" & If ($years <> "1","s") & " " & $Months & "mth" & If($Months<>"1","s");
If($years<>"" and $Months<>"", $RawResult)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- LauraDiak5 years agoQrew TraineeThank you.
------------------------------
Laura Diak
------------------------------