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:
Hello,
If you want to have something like that I would recommend creating a PCF control for that purpose.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156