Format date parameters

Hi,
I have a start date (date/time) parameter with a default value of
=DateTime.Today & a end date (date/time) parameter with a default value of
=DateTime.Today.adddays(7)
These parameters query a short date field in an access database
Could i please have some assistance around taking off the time element in
the parameters.
ThankyouI have an example at www.msbicentral.com under downloads, RS, RDLs... The
file name is Parameters.FormattedDates.RDL
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Tango" <Tango@.discussions.microsoft.com> wrote in message
news:4F30DFD9-897B-495A-B75D-A043E75A61D3@.microsoft.com...
> Hi,
> I have a start date (date/time) parameter with a default value of
> =DateTime.Today & a end date (date/time) parameter with a default value of
> =DateTime.Today.adddays(7)
> These parameters query a short date field in an access database
> Could i please have some assistance around taking off the time element in
> the parameters.
> Thankyou|||Thanks Wayne.
Nice site...
"Wayne Snyder" wrote:
> I have an example at www.msbicentral.com under downloads, RS, RDLs... The
> file name is Parameters.FormattedDates.RDL
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Tango" <Tango@.discussions.microsoft.com> wrote in message
> news:4F30DFD9-897B-495A-B75D-A043E75A61D3@.microsoft.com...
> > Hi,
> >
> > I have a start date (date/time) parameter with a default value of
> > =DateTime.Today & a end date (date/time) parameter with a default value of
> > =DateTime.Today.adddays(7)
> > These parameters query a short date field in an access database
> > Could i please have some assistance around taking off the time element in
> > the parameters.
> > Thankyou
>
>