Re: Get Start Date of a Week Number

[Booth Martin <booth@xxxxxxxxxxxx>]

I see a couple of solutions.  The simplest is to:

1. Find the offset from your desired First-day-of-week, in days, for
   the first day of the target year from the the first day of Week1 *

      wOffset = %diff(FirstDateOfTargetYear: wTestDate: *days);
      wOffset = %rem(wOffset: 7);

   *
2. multiply the week# by 7; that gives you the Julian Date for that
   particular week.
3. Subtract the offset from the Julian Date *First-Date-of-week* =
   JulianDate - %days(wOffset);

I have not tested this; it is pretty likely in need of some tuning.   
wTestDate is any fixed first day of the week of Week 1in a past year, 
whether a Sunday, Saturday, whatever.  Your choice.


On 11/26/2014 8:52 AM, Brian wrote:
> Hello All,
>
> I have the need to get the date of the first day of the week based on a
> week number.  I've looked thorough lots of date functions and can't seem to
> see a way to get the date of the first day of the week for a particular
> week number.  Maybe I need a multi-step process, but I am just struggling
> to see it.
>
> The date can be based off Sunday or whatever arbitrary day could be
> considered as the first day of the week, if that helps.
>
> The data is planning data so I really just need to show it as a quantity
> along with a date, but the date needs derived from a week number.
>
> As an example, if I had week number of 1, the date might be 12/29/2014,
> week 2 would give me 1/5/2015 and so on.
>
> Can anyone provide some suggestions on a method to get to a date based off
> the week number?
>
> Thank you.