+ 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