Week Ending Date

Given a date, this formula calculates the week ending date.
For eg.
if the given date is 06/07/2000(mm/dd/yyyy format)
then this formula calculates the weekend saturday date as 06/10/2000.
if the given date is a saturday, then it is the same as the weekend date.
strtDay := @Weekday(GivenDate);
weekday := @If(strtDay < 7;@Adjust(Givendate;0;0;(7-strtday);0;0;0);Givendate);
This was first published in November 2000

Dig deeper on Domino Resources - Part 5



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:



  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...