salesforce.com‎ > ‎code‎ > ‎

[数式]年齢計算

2011/09/30 9:30 に Makoto Fukasu が投稿   [ 2013/05/15 6:59 に更新しました ]
IF( MONTH(Today()) > MONTH(Birthday__c), YEAR(Today()) - YEAR(Birthday__c), If( AND(MONTH(TODAY()) = MONTH(Birthday__c), DAY(TODAY()) >= DAY(Birthday__c), YEAR(TODAY()) - YEAR(Birthday__c), YEAR(TODAY()) - YEAR(Birthday__c) - 1 ) )
FLOOR((TODAY() - Birthday__c) / 365.2425)
Comments