Re: date processing for end of week

[Adam Glauser <adamglauser@xxxxxxxxxxxx>]

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.

Let me try to restate this to make sure I understand.  You want to read 
through all the back orders and print (for example) the total number of 
orders and total value expected to be paid for each (Friday-ending) week?

One possible solution would be to program something like this:
  today      = today's date
  thisFriday = nextFriday(today)

  for each order
    payDate    = td + payByDays(billedCustomer)
    payWeekEnd = nextFriday(payDate)
    payWeek    = (payWeekEnd - thisFriday) in weeks

    totalOrders[payWeek] += 1
    totalValue[payWeek] += orderValue

where nextFriday(inputDate) goes something like:
  fridayDate = inputDate + ((DAY_FRIDAY - dayOfWeek(inputDate)) in days)

dayOfWeek(inputDate) should return 7 for Friday, 6 for Thursday, 5 for 
Wednesday, etc.

SQL has a function to return the day of the week, which you could use to 
implement your dayOfWeek function.

Hope this helps,
Adam