Hi all,
I would like to know that is it possible to show the calculated Day, Month, Year in one field on the form.
I mean that is the difference between two dates is in days then it should show no. of days.
If the difference between two dates is in months the it should show no. of months and so on.
I have no idea how can I bring a best solution for this. Please let me know if there is solution.
Thank you.
Hi Leah,
Thank you so much for the response.
I am trying to do replicate exactly as you explained. But, my requirement is I need to see all Year,Month,Day in one field.
Can I concat the fields to show in one field.
for example : I have one day it shows only 1day
If its 1month and 2days it should also show that.
Hi Sravz,
You can achieve it through calculated fields and business rule.
Steps:
1.Create custom fields and add them to the form:
(1)Three calculate fields to store difference in years/months/days.
(2) Uncheck 'Visible by default' option for these three fields in the form.
2.Create a business rule to populate 'Result' field automatically.
Years greater than 0
Months greater than 0
3.Test Result:
Change date and save current record:
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
