Help

Re: Hola, como puedo hacer una formula para calcular la edad en años y meses?

Solved
Jump to Solution
767 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rossi
4 - Data Explorer
4 - Data Explorer
 
1 Solution

Accepted Solutions
TheTimeSavingCo
17 - Neptune
17 - Neptune

Usé Google Translate y dijo que te gustaría calcular la edad en años y meses. Si eso es correcto, echa un vistazo a esto*:

Screenshot 2023-02-09 at 1.16.20 PM.png

DATETIME_DIFF(
  TODAY(),
  Date,
  "years"
) 
& " years, " 
& (DATETIME_DIFF(
    TODAY(),
    Date,
    "months"
  ) - 
  DATETIME_DIFF(
    TODAY(),
    Date,
    "years"
  ) * 12
)
& " months"

 Base

*I used Google Translate and it said that you'd like to calculate age in years and months?  If that's correct, have a look at this:

See Solution in Thread

3 Replies 3
TheTimeSavingCo
17 - Neptune
17 - Neptune

Usé Google Translate y dijo que te gustaría calcular la edad en años y meses. Si eso es correcto, echa un vistazo a esto*:

Screenshot 2023-02-09 at 1.16.20 PM.png

DATETIME_DIFF(
  TODAY(),
  Date,
  "years"
) 
& " years, " 
& (DATETIME_DIFF(
    TODAY(),
    Date,
    "months"
  ) - 
  DATETIME_DIFF(
    TODAY(),
    Date,
    "years"
  ) * 12
)
& " months"

 Base

*I used Google Translate and it said that you'd like to calculate age in years and months?  If that's correct, have a look at this:

Hi,

just a suggestion - you can also use MOD ( ...months.., 12) for such expressions.

Oooh, you're right, that's a lot cleaner!