Calculate age: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
(Created page with "Calculate age in Excel or MySQL == In Excel == If the column value is well-formatted * {{kbd | key=<nowiki>=(TODAY()- BIRTH_DAY)/365</nowiki>}}<ref>[https://www.ablebits.com...") |
mNo edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
Calculate age in Excel or MySQL | Calculate age in Excel or MySQL | ||
== | == Calculate age in Excel == | ||
If the column value is well-formatted | If the column value is well-formatted | ||
| Line 7: | Line 7: | ||
* {{kbd | key=<nowiki>=ROUNDDOWN(YEARFRAC(BIRTH_DAY, TODAY(), 1), 0)</nowiki>}} | * {{kbd | key=<nowiki>=ROUNDDOWN(YEARFRAC(BIRTH_DAY, TODAY(), 1), 0)</nowiki>}} | ||
== | == Calculate age in MySQL == | ||
<pre> | <pre> | ||
| Line 16: | Line 16: | ||
<ref>[https://stackoverflow.com/questions/5773405/calculate-age-in-mysql-innodb sql - Calculate Age in MySQL (InnoDb) - Stack Overflow]</ref> | <ref>[https://stackoverflow.com/questions/5773405/calculate-age-in-mysql-innodb sql - Calculate Age in MySQL (InnoDb) - Stack Overflow]</ref> | ||
== Challenge of real world data == | |||
The column value is '''NOT''' well-formatted such as | |||
* year only e.g. {{CURRENTYEAR}} | |||
* month & date only e.g. {{CURRENTMONTH}}-{{CURRENTDAY}} | |||
== References == | == References == | ||
<references /> | <references /> | ||
[[Category:Excel]] [[Category:MySQL]] | [[Category:Excel]] [[Category:MySQL]] [[Category:Time river]] | ||