How to Get Last Working Day of the every month

Certified Senior Developer

Hi Team,

I need Last working Day date of every month as i need to start process for every month Last working day.

Let's say if i take Aug-2025 Month & its month end date is 31st & falls on Sunday but in my case process should trigger on 29th Aug which is a last working day.

I need dynamic approach so that it iwll pick last working date & start process.

prompt response really appreciated,Thanks

  Discussion posts and replies are publicly visible

Parents Reply
  • 0
    Certified Lead Developer
    in reply to Shukur Shaik

    You can use below expression

    a!localVariables(
      /* Replace with your own holiday list or a rule that fetches them dynamically */
      local!holidays: {
        date(2025,8,15),
        date(2025,8,28) 
      },
    
      /* Get the last calendar day of the current month */
      local!lastDay: eomonth(today(), 0),
    
      /* Calculate last working day by moving backwards 1 workday from lastDay+1 */
      local!lastWorkingDay: workday(
        local!lastDay + 1, 
        -1,                
        local!holidays    
      ),
    
      local!lastWorkingDay
    )
    

Children
No Data