function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Hussain HajiHussain Haji 

hi need help in forumal

want to create a forumal filed witht the below logicet 

Represents Days,Hours 
Calculates the total duration of time since the record create time till now or till Closed Won/Lost time , with counting the weekend days friday and saturday on working days
Hussain HajiHussain Haji
sorry without couting the weekend only weekdays 
Nitin SharmaNitin Sharma
use TODAY () - DATEVALUE(CreatedDate) 
Nitin Wader 21Nitin Wader 21
I have had similar requirement but without counting weekends is something you need to do on your own.

In normanl cases [including weekends] formula provided above is fine.

 
Hussain HajiHussain Haji
thanks i will try it 
Hussain HajiHussain Haji
am useing the below , i want to remove the weekend from the counting , any can help please .

if(not(  OR(ISPICKVAL(StageName , 'Lost'),ISPICKVAL(StageName , 'Won')) ),NOW() -  CreatedDate, CloseDate -DateValue( CreatedDate))