[AccessD] Re: AccessD Digest, Vol 12, Issue 63

Christopher,
You could try the following:

StartOfCurrentWeek = dateadd("d", 1 - Weekday(Now()), Now())

EndOfCurrentWeek=dateadd("d",  Weekday(Now())-7, Now())

I hope that this helps,
David


At 04:09 28/02/2004 -0600, accessd-request at databaseadvisors.com wrote:
>Date: Fri, 27 Feb 2004 16:26:58 -0700
>From: "Christopher Hawkins" <clh at christopherhawkins.com>
>Subject: [AccessD] Getting the start and end dates of the current week
>To: accessd at databaseadvisors.com
>Message-ID: <95540-220042527232658264 at christopherhawkins.com>
>Content-Type: text/plain; charset=iso-8859-1
>
>I need a function that will determine the start and end dates of the
>current week.  I'm hacking around with some code, but I'm not
>producing enything useful.  Surely I'm not the first to have this
>problem?
>
>-Christopher-