Re: Getting last Friday’s date

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.