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
Sean ClarkSean Clark 

Process Builder Formula Criteria

Hi Guys,

I have a process builder with certain criteria, i want to add another criteria to say if the Created Date equals This Week and another one to say if the Created Date equals Next Week.

I have been looking everywhere for this info but can't find it. 

Hope someone can help! 
Akhil ReddyAkhil Reddy
This is will give Week of the Year a Date Is In
IF( CEILING( ( date - DATE( YEAR( date ), 1, 1) + 1) / 7) > 52, 52, CEILING( ( date - DATE( YEAR( date ), 1, 1) + 1) / 7) )

So if the Created date is Today is in same week then it is this week, if the difference Today week - created week = 1 then it is in next week