[AccessD] Need to derive the "Start" and "End" dates from a "DatePart Week Number"

If Weekday starts on Sunday (which I assume it does as per your datepart
example below)

Week Starting: (CDate("01/01/" & 2012) - WeekDay("01/01/" & 2012,
vbMonday))+7 * (DatePart("ww",WeekNumber))

 Can test in debug window:
?(CDate("01/01/" & 2012) - WeekDay("01/01/" & 2012, vbMonday))+7 *
(DatePart("ww",Date()))


HTH
David McAfee



On Thu, Aug 9, 2012 at 1:43 PM, Brad Marks <BradM at blackforestltd.com> wrote:

> All,
>
> I have a small report that summarizes the number of new orders by week.
> The report's underlying query uses "DatePart" like this.
>
>
> OrderWeek: DatePart("ww",[OrderDate])
>
>
>
> Here is a small sample of what the report looks like.
>
> ~~~~~~~~~~~~
> Week  Nbr-of-Orders
> 16         333
> 17         355
> ~~~~~~~~~~~~~
>
> I have been asked to spell out what the start and end dates are for each
> week number on the report.
>
> Is it possible to derive the "Start" and "End" dates from a week number?
>
> Thanks,
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>