Re: date processing for end of week

This code is pretty old, but the concept is pretty easy once the light bulb goes on.

http://www.martinvt.com/Code_Samples/Date_Math/date_math.html

Every week has 7 days, right? So pick any Friday, since that is the day of the week you want. Then find the number of days between that date and your target date. Divide by 7 and /discard/ the result and /save/ the remainder. That remainder is your off-set from Friday, in days. You need to tinker with it. For example, what if the order date is Friday? Does that go in this week or next week? But you get the idea, right?

Adam West wrote:

HI I have a need to look at a file of back orders, and assume, for the sake of the report, that each back order will be shipped today and the customer will pay by the end of the terms date that they have, e.g. net 10 days, net 30 days etc.

This will then be printed as a report to the week ending day of Friday for that particular week in the future.

So if order A, is due in 20 days, it would be part of a bucket for that week. But you never know your starting point, it could be 10,20,25, 30,etc days into the future. How then can you know when Friday is in that particular week in an automated fashion?
TIA,