Using WHERE statement to display date range

[Dan Matthews]

I have a multi-year events database that is displayed on the web. But
I also would like to display events from that database one week at a
time. Does anyone know how to do that? Thanks in advance.

If you have any questions, please ask.

Dan Matthews, MCP
Technology Manager
Green Hall, University of Kansas
(785) 864-9267
[email]dmatthews@ku.edu[/email]
[url]http://www.people.ku.edu/~dmatthew/[/url]

[Chris Hohmann]

"Dan Matthews" <dmatthews@ku.edu> wrote in message
news:eed3ba41.0308010809.2121cff9@posting.google.c om...

> I have a multi-year events database that is displayed on the web. But
> I also would like to display events from that database one week at a
> time. Does anyone know how to do that? Thanks in advance.
>
> If you have any questions, please ask.
>
> Dan Matthews, MCP
> Technology Manager
> Green Hall, University of Kansas
> (785) 864-9267
> [email]dmatthews@ku.edu[/email]
> [url]http://www.people.ku.edu/~dmatthew/[/url]

Database? Version? Table Structure?

[Manohar Kamath [MVP]]

In Access, the date is delimited by #. In SQL Server, just enclose the date
in 's.

WHERE myDate=#8/1/2003#

WHERE myDate='8/1/2003'

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"Dan Matthews" <dmatthews@ku.edu> wrote in message
news:eed3ba41.0308010809.2121cff9@posting.google.c om...

> I have a multi-year events database that is displayed on the web. But
> I also would like to display events from that database one week at a
> time. Does anyone know how to do that? Thanks in advance.
>
> If you have any questions, please ask.
>
> Dan Matthews, MCP
> Technology Manager
> Green Hall, University of Kansas
> (785) 864-9267
> [email]dmatthews@ku.edu[/email]
> [url]http://www.people.ku.edu/~dmatthew/[/url]

[Dan Matthews]

Thanks for the responses!

I was looking for a syntax clarification and I eventually came up with:

....WHERE (Events.StartDate >= Date() AND Events.StartDate <= Date() + 7) ORDER BY...

and that worked. Again, thanks for the responses!

If you have any questions, please ask.

Dan Matthews, MCP
Technology Manager
Green Hall, University of Kansas
(785) 864-9267
[email]dmatthews@ku.edu[/email]
[url]http://www.people.ku.edu/~dmatthew/[/url]

"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in message news:<eJJfFoLWDHA.388@TK2MSFTNGP10.phx.gbl>...

> In Access, the date is delimited by #. In SQL Server, just enclose the date
> in 's.
>
> WHERE myDate=#8/1/2003#
>
> WHERE myDate='8/1/2003'
>
> --
> Manohar Kamath
> Editor, .netBooks
> [url]www.dotnetbooks.com[/url]
>
>
> "Dan Matthews" <dmatthews@ku.edu> wrote in message
> news:eed3ba41.0308010809.2121cff9@posting.google.c om...

> > I have a multi-year events database that is displayed on the web. But
> > I also would like to display events from that database one week at a
> > time. Does anyone know how to do that? Thanks in advance.
> >
> > If you have any questions, please ask.
> >
> > Dan Matthews, MCP
> > Technology Manager
> > Green Hall, University of Kansas
> > (785) 864-9267
> > [email]dmatthews@ku.edu[/email]
> > [url]http://www.people.ku.edu/~dmatthew/[/url]