Skip to Main Content
HCL Domino Ideas Portal

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

Status Under Consideration
Workspace Domino Designer
Categories @Formulas
Created by Guest
Created on Feb 8, 2024

@businessdays seems to be broken (tested in V12)

It looks like @businessdays is not working as expected (anymore?). It shows number of days between to values (also very handy :-), however not business days.

_d := @adjust(@today;0;0;-7;0;0;0);
@BusinessDays(_d;@Today)

This wil result in 8 where I was expecting 6.

  • Attach files
  • Admin
    Thomas Hampel
    Reply
    |
    Apr 3, 2024

    It seems this is a bug, so can you please officially report this as a support ticket?
    https://support.hcltechsw.com/csm

  • Guest
    Reply
    |
    Mar 5, 2024

    Indeed. Overlooked this. Will test tomorrow, but assume this will work. Tnx a lot

  • Admin
    Thomas Hampel
    Reply
    |
    Mar 5, 2024

    Very good comment!

  • Guest
    Reply
    |
    Feb 9, 2024

    According to Designer Help the syntax is: @BusinessDays( startDates ; endDates ; daysToExclude ; datesToExclude ).

    Assuming that Sunday (1) and Saturday (7) are non-business days, you could try @BusinessDays(_d; @Today; 1 : 7) to get what you expect.