Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
6 replies
Answers
1 answer
Subscribers
8 subscribers
Views
9107 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hello, Can someone recommend the best way of calculating age in years, mont
Adel Ammari
over 9 years ago
Hello,
Can someone recommend the best way of calculating age in years, months and days, by taking only a birth date / start date?
Taking into consideration leap years and difference in days of the month, as they might be 28,29,30 or 31 days.
Example input would be: 1/10/2014 [1st October 2014]
Result on 2/4/2015 [2nd April 2015] would be: 0 years 6 months 1 days
Thanks
OriginalPostID-144093
OriginalPostID-144093
Discussion posts and replies are publicly visible
Top Replies
Anurag
over 3 years ago
+4
suggested
I have created expression rule to calculate age (in year) based on birth date. Below is for reference, can be modified further to get month and days also: if( month(today())>month(ri!dob), year(today…
PhilB
over 9 years ago
+2
A Score Level 1
I have a feeling (although I haven't tested it) that conor's example might oversimplify this and won't be quite right for certain dates - either that, or I'm overcomplicating it. Either way, feel free…
Parents
0
PhilB
A Score Level 1
over 9 years ago
No problem!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
PhilB
A Score Level 1
over 9 years ago
No problem!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data