Re: MS SQL 2000
From: Hugo Kornelis <hugo_at_pe_NO_rFact.in_SPAM_fo>
Date: Mon, 10 Jan 2005 20:54:26 +0100
Message-ID: <l9n5u05e2k0flphl15ghtdagh8kmmphu5d_at_4ax.com>
Date: Mon, 10 Jan 2005 20:54:26 +0100
Message-ID: <l9n5u05e2k0flphl15ghtdagh8kmmphu5d_at_4ax.com>
On 10 Jan 2005 09:10:14 -0800, Kirby wrote:
>I need an sql WHERE statement to extra data where the Job.JobDate is
>between the current date and the current date + two weeks.
Hi Kirby,
To calculate the current date plus two weeks, you use DATEADD (week, 2, Job.Jobdate)
The rest of your statement is trivial. The DATEADD function is described
in detail in Books Online.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)
Received on Mon Jan 10 2005 - 20:54:26 CET