Re: can you reassign week numbers
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 28 Dec 2007 19:15:52 -0700
On Fri, 28 Dec 2007 17:14:49 -0800 (PST), Pat <pwagaman@xxxxxxxxxxx> wrote:
okay, my start date would be the "In Date". Can you give me an
example????? Please and thank you.
DateDiff("ww", [In Date], Date())
will return the number of weeks (Sundays) between In Date and today's date.
John W. Vinson [MVP]
.
- Follow-Ups:
- Re: can you reassign week numbers
- From: Pat
- Re: can you reassign week numbers
- References:
- can you reassign week numbers
- From: Pat
- Re: can you reassign week numbers
- From: Pat
- Re: can you reassign week numbers
- From: Jeff Boyce
- Re: can you reassign week numbers
- From: Pat
- can you reassign week numbers
- Prev by Date: Re: query not correct: between dates ?
- Next by Date: Re: query criteria
- Previous by thread: Re: can you reassign week numbers
- Next by thread: Re: can you reassign week numbers
- Index(es):