Forum Discussion
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
------------------------------
LauraDiak
5 years agoQrew Trainee
Thank you.
------------------------------
Laura Diak
------------------------------
------------------------------
Laura Diak
------------------------------