Prev: Required field based on combo box selection
Next: Variable in module to reference form
From: Ken on 1 Jul 2008 13:41


"John Vinson" wrote:

> On Wed, 10 May 2006 08:04:01 -0700, Sarah
> <Sarah(a)discussions.microsoft.com> wrote:
>
> >Does anyone know of a function or set of functions which can retrieve the
> >week number for a given date?
> >
> >For example: Given date 1/16/2006 would return 3 for the 3rd week in the year.
> >
> >Thanks,
> >
> >Sarah
> >
>
> DatePart("ww", [datefield])
>
> Open the VBA editor and look at the Help for DatePart. There are
> several options to determine what is the first week of the year (If
> January 1 were a Saturday, is January 3 in the first week or the
> second?)
>
> John W. Vinson[MVP]
>
From: Ken on 1 Jul 2008 13:44
does someone know how to convert my weekly date format into a short date?

My data reads YYYYWW - (i.e. 200801 is the first week in 2008)

I need to use 01/31/08 in form selection for the corresponding week in the
table -

Thanks,

"Jeff Boyce" wrote:

> Sarah
>
> I don't recall if there's a specific function (there easily could be, I just
> don't recall), but you could use a query and the Format() function to
> display a date as a week number.
>
> Check Access HELP for Format() and for date-related functions.
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "Sarah" <Sarah(a)discussions.microsoft.com> wrote in message
> news:1B55D161-BB09-4372-B32E-16804A38F03E(a)microsoft.com...
> > Does anyone know of a function or set of functions which can retrieve the
> > week number for a given date?
> >
> > For example: Given date 1/16/2006 would return 3 for the 3rd week in the
> > year.
> >
> > Thanks,
> >
> > Sarah
> >
> >
>
>
>
 | 
Pages: 1
Prev: Required field based on combo box selection
Next: Variable in module to reference form