Customer experience | Sales, Customer Insights,...

JavaScript code for Formula field

(0) Share

Report

Posted on by Shawn Low

Good Afternoon All,

I am new to Dynamics 365 CRM and I am trying to create a formula (Calculated) field that counts the number of days between two dates (created on date and today), not counting weekends.

I am not a developer and do not know how to write JavaScript. I have tried code generators but they did not help much.

Does someone have a JavaScript code that they can and would be willing to share with me?

Thank you

Shawn Low

All responses (2)

Answers (0)

Leah Ju Microsoft Employee on at

Like (0)

Report

JavaScript code for Formula field

Hi Shawn,

It seems that Formula field can't achieve it.

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Using-a-calculated-field-and-DIFFINDAYS-to-exclude-weekends/td-p/2203264

Maybe you can consider using workflow:

https://www.crmconsultants.co.uk/calculate-duration-of-business-days-in-dynamics-365-crm/#:~:text=workflow%20menu%20and%20select%20the,Dates%20of%20the%20Duration%20Calculation.
Suggested answer

Adrian Begovich 21,009 Super User 2024 Season 2 on at

Like (0)

Report

JavaScript code for Formula field

Hi Shawn,

You can find JavaScript code that does this here.

Quick Links

Leaderboard

André Arnaud de Cal... 291,240 Super User 2024 Season 2

Martin Dráb 230,149 Most Valuable Professional

nmaenpaa 101,156

Leaderboard

JavaScript code for Formula field

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Leaderboard

Featured topics

Product updates

JavaScript code for Formula field

Helpful resources

News and Announcements

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Community AMA December 12th

Subscribe to

Leaderboard

Featured topics

Product updates