# Getting problem in creating simple TF formula

I want to have time in year and months from some date but it is showing me in decades. I tried Y and y, and M as argument but no use. I do not want answer in decades but in year month and days. please tell me i am new. \$tf(1999y30M14d)\$

Same problem, i 2nd this.

Well i made this to count days since i born

Today I am \$if(df(M)>=4,df(y)-1994,df(y,r1y)-1994)\$ Years \$if(df(M)>=4,df(M)-4,df(M)+8) \$ Monthas and \$if(df(d)>=30,(if(df(d)=30,"0","1")),df(d))\$ Days old.

Sorry for the delay, the tf() function accepts a format as well, so you can do:

\$tf(1999y30M14d, "'Was 'D' days 'h' hours and 'm' minutes ago'")\$

Or simpy "It was \$tf(1999y30M14d, D)\$ days ago"

Is that what you are looking for?

No i do not want the time in days butbin years.

To get years you can do "\$tf(1999y30M14d, D) / 365\$" to get remaining days in the year \$tf(1999y30M14d, D) % 365\$

can you explain further? in terms of how to put the numbers. the birthday i would like to calculate the age is 21/5/2017

I'm trying to do a sobriety counter... I got sober August 20th 2016 and can't figure this out

Hye!

Is. It possible to have a tf() between 2 different date ? Or to. Add days on a date (not the current one)?

Thanks

here is a code wich make count between current day and past date :

\$if(df(M)<df(M,gv(birthday)),df(yyyy)-df(y,gv(birthday))-1,df(yyyy)-df(y,gv(birthday)))\$ ans, \$if(df(d)<df(d,gv(birthday)),df(M)-df(M,gv(birthday))-1,df(M)-df(M,gv(birthday)))\$ mois, \$if(df(d)<df(d,gv(birthday)),df(o,dMyr1M)-df(d,gv(birthday))+df(d),df(d)-df(d,gv(birthday)))\$ jours

where in gv(Birtday) you put date like 1982y06M24d

and of course you adapt ans (year), mois (months) and jours (days) in your speaking

this code take care of nomber of days in month because a month it is not an accurate date value, it nevers has the same value.

if you have any question, do not hesitate.

here is a code wich make count between current day and past date :

\$if(df(M)<df(M,gv(birthday)),df(yyyy)-df(y,gv(birthday))-1,df(yyyy)-df(y,gv(birthday)))\$ ans, \$if(df(d)<df(d,gv(birthday)),df(M)-df(M,gv(birthday))-1,df(M)-df(M,gv(birthday)))\$ mois, \$if(df(d)<df(d,gv(birthday)),df(o,dMyr1M)-df(d,gv(birthday))+df(d),df(d)-df(d,gv(birthday)))\$ jours

where in gv(Birtday) you put date like 1982y06M24d

and of course you adapt ans (year), mois (months) and jours (days) in your speaking

this code take care of nomber of days in month because a month it is not an accurate date value, it nevers has the same value.

if you have any question, do not hesitate.