Calculate Age in calculated field/flow field

(0) Share

Report

Posted on by Community Member

Hi all,

I am thinking how can I get an "Age" field display in the page and make sure the age will change date by date. I think sth like flow field is good but cannot find suitable function. Can anyone suggest? Thanks!

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

The requirement you have is not clear. Do you want a field (Age) that is automatically updated when opening a page? If so, you can create a flowfield or maybe a function that calculates the Age for the current record. Then on the page place a field with SourceExpression = your function and trigger the function calculation in OnAfterGetRecord.

Was this reply helpful? Yes No
Verified answer

Zaid Tariq 2,274 on at

Like (0)

Report

Hi,

Can you please elaborate a bit about what you mean by suitable function? I guess the simple formula is your DBO - TODAY and you will have the age. From development perspective you can use Age := DATE2DMY(TODAY, 3) - DATE2DMY(DOB,3) but it will compare will give you number of years difference. This is very simple and basic logic but if you want exactly correct calculating you need to write some code.

forum.mibuso.com/.../calculate-difference-between-two-dates

Let me know if you still have any query. Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Stefano, just notice I can customize like this.

Was this reply helpful? Yes No