Overdue days

HCL Domino Domino Forum
1

Hello!

I have to put inside my database the expected end date, when the project should be finished. In case, that it is not finished till this date, I want to count overdue days.

I have a form, with a end date, I can resolve through @Now function current date, so I need to do current_date-expected_end_date.

How should my formula look like?

Thank you

2

Subject: Overdue days

err - you’ve got it!diff:=current_date - expected_end_date

diff is in seconds

3

Subject: Overdue days

@BusinessDays

you can then exclude weekends, holidays etc.

@BusinessDays( YourExpectedEndDate ; @Now ; 1: 7 ; lookupToNAB4Hols )