Re: date processing for end of week

[Adam Glauser <adamglauser@xxxxxxxxxxxx>]

Adam West wrote:
> another thing is I need to have a total owed bucket for each Friday that comes into play.

We've told you a number of ways to get the Friday after a given date. 
Now that you know how to do that, please read this post* again. I'll 
describe in words what I'm suggesting with my pseudocode there.

First you figure out the next Friday after today (nextFriday).  Next you 
figure out the Friday due date for the order (payWeekEnd).  Now 
determine the number of weeks between nextFriday and payWeekEnd 
(payWeek). You can use %diff() or SUBDUR to calculate this value.  Now 
you just need an array with the maximum number of weeks (totalValue). 
This would be 26 based on your earlier statement the future date could 
be up to 180 days away.  Add each order amount to totalValue[payWeek].

You've been given a bunch of good suggestions so far.  Please take the 
time to read them thoroughly and think about them.

Hope this helps,
Adam

* http://archive.midrange.com/rpg400-l/200811/msg00169.html

> I have this to get me my due date
> c     mydate        adddur    duedays:*days datedue       
>
> but how to then add to correct bucket? Would there be afield that would indicate week1,2 etc of a particular month?
>
> Is this only possible to do in SQL?
> If so, how do I do this.
>
> I am willing to code a table of weeks and compare against it but I don't think the dates are the same types.
>
>
>
> ________________________________
> From: Adam Glauser <adamglauser@xxxxxxxxxxxx>
> To: rpg400-l@xxxxxxxxxxxx
> Sent: Wednesday, November 12, 2008 1:38:34 PM
> Subject: Re: date processing for end of week
>
> Adam West wrote:
> > My question is, how does the program know when the next Friday is?
>
> By figuring out what day of the week today is, then adding the 
> difference between today and Friday.
>
> If you don't want to use SQL, you could implement one of the day of week 
> algorithms* for the Gregorian calendar.
>
> HTH,
> Adam
>
> * http://en.wikipedia.org/wiki/Calculating_the_day_of_the_week