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 1,025 Super User 2025 Season 1 on at

Like (0)

Report

JavaScript code for Formula field

Hi Shawn,

You can find JavaScript code that does this here.

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Community site session details

JavaScript code for Formula field

Helpful resources

News and Announcements

Quick Links

Jainam Kothari – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard >

Featured topics

Product updates

Community site session details

JavaScript code for Formula field

Helpful resources

News and Announcements

Quick Links

Jainam Kothari – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard >

Featured topics

Product updates