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
Thanks Stefano, just notice I can customize like this.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (