Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
I have an issue with DIFFINDAYS formula in Calculated field. It calculates days difference based on Calendar days. It is not excluding holidays and weekends. I found many plugin codes to set/update a static field on form. But, I need this logic to work on a calculated field on Advanced Find personal view so that it calculates dynamically when ever view is opened/refreshed.
Is it possible to write my own custom function to calculate days difference based on my own logic? Can someone help me how to address this?
FYI, I tried an alternative method to use JScript webresource and call a function on Column property of Personal View on Advanced find. See the below image. But I am not sure how to set and display dynamics calculated values on a Column of view. Is there any Jscript statement to set value to a column on view?
Ideas are most welcome and Many thanks in advance.
Javacript will not be a good solution as it changes the value on the browser and not in the actual database. So assuming you are able to achieve this using JS, the users will notice descepencies when they actualy opened the record.
Also, calculated field will use calendar day which is by design and cannot be changed. What you can do is to write your own custom implementation. There is a workflow utility which you can use-
Its a workflow activity so you can add it yourworkflow which you can then trigger on create/update. This will not work on Views or when the record is opened so for that you can trigger this workflow using this plugin on Retrieve & Retrieve multiple. This can be done by triggering the workflow by som dummy field and on set that field inside your plugins.
Hope this helps.
You can instead right a plugin on RetrieveMultiple message and have the logic displayed as you want.
Business Applications communities