Re: Getting last Friday’s date

[Brad Stone <bvstone@xxxxxxxxx>]

Here's an old one I  used to get the day of the week as an integer.. should
be easy enough to get from that.

1.  Get the day of the week.
2.  If it's Friday, the date you passed in is good.
3.  If not, subject x days from the date to get friday.

      *//////////////////////////////////////////////////////////////*
      * #DayOfWeek - Return the Day of the Week                      *
      * 1=Sun, 2=Mon, etc.. etc..                                    *
      *//////////////////////////////////////////////////////////////*
     P #DayOfWeek      B                   Export
      *--------------------------------------------------------------*
     D #DayOfWeek      PI            10I 0
     D  DateIn                         Z   Const
      *
     D DayOfWk         S             10I 0
      *--------------------------------------------------------------*
     C     DateIn        SUBDUR    D'1998-08-01' DayOfWk:*D
     C                   DIV       7             DayOfWk
     C                   MvR                     DayOfWk
      *
     C                   if        (DayOfWk > 0)
     C                   RETURN    DayOfWk
     C                   else
     C                   RETURN    DayOfWk + 7
     C                   endif
      *--------------------------------------------------------------*
     P #DayOfWeek      E

On Thu, Aug 3, 2023 at 2:30 PM Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
wrote:

> I need to retrieve the date from last Friday.  If it is Friday, I want the
> current date.  Anyone have a routine that does that before I start
> developing one?   Seem like a good SQL problem but the program using it
> would be in CLLE.
>
> Thoughts?
> --
>
> --
> Jim Oberholtzer
> Chief Technical Architect
> Agile Technology Architects
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.