There is a post that tells how to do this:
>>Use =Today() and set the field format to d
but where do you set the field format of a parameter?
--
Michael White
Programmer/Analyst
Marion County, ORHave you tried inserting the parameter on the report and then right click
properties and set format?
Another option is using code file.
"Michael" <xxx.xxx.xxx> wrote in message
news:%23g16Kjn%23EHA.1392@.tk2msftngp13.phx.gbl...
> There is a post that tells how to do this:
>>Use =Today() and set the field format to d
> but where do you set the field format of a parameter?
> --
> Michael White
> Programmer/Analyst
> Marion County, OR
>|||I don't think you can set the format of a parameter past the fact that it is
a date, but the time does NOT have to be entered when using the parameter.
Some people choose to use the string data type instead of date...
--
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
"Michael" <xxx.xxx.xxx> wrote in message
news:%23g16Kjn%23EHA.1392@.tk2msftngp13.phx.gbl...
> There is a post that tells how to do this:
> >>Use =Today() and set the field format to d
> but where do you set the field format of a parameter?
> --
> Michael White
> Programmer/Analyst
> Marion County, OR
>|||Wayne described what I do. I create the parameter as a string. My stored
procedures then convert the string to datetime datatypes. If you don't do
somthing similar, the parameter fields on the report append hh:mm:ss to the
parameter value supplied.
Mardy
"Wayne Snyder" wrote:
> I don't think you can set the format of a parameter past the fact that it is
> a date, but the time does NOT have to be entered when using the parameter.
> Some people choose to use the string data type instead of date...
> --
> 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
> "Michael" <xxx.xxx.xxx> wrote in message
> news:%23g16Kjn%23EHA.1392@.tk2msftngp13.phx.gbl...
> > There is a post that tells how to do this:
> >
> > >>Use =Today() and set the field format to d
> >
> > but where do you set the field format of a parameter?
> >
> > --
> > Michael White
> > Programmer/Analyst
> > Marion County, OR
> >
> >
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment