Prev: Report Parameters in SQL 2008
Next: SOAP Webservice Data Source (Input object type)
From: John on 1 Jun 2010 07:07
Hi all,

I am getting the results from reporting services using Excel as datasource.
The date format is dd/mm/yyyy hh:mm:ss.

I want out put from reporting services should be dd/mm/yyyy only.

I am using the query as:

select date from Excel$
where datepart("m",date) = datepart("m",@rundate).

please help to modify the query.
From: Patrice on 1 Jun 2010 14:00
Hello,

> please help to modify the query.

Use the format property in the Report Designer (should be d or
dd/MM/yyyy)...

--
Patrice



From: John on 2 Jun 2010 06:22
Hi Patrice,

Lesson 5 (Formatting a Report) helped as usual. Thanks for your suggestions.

Design>Text Box Properties> Number> Category> Date> Type> January 31, 2000

"Patrice" wrote:

> Hello,
>
> > please help to modify the query.
>
> Use the format property in the Report Designer (should be d or
> dd/MM/yyyy)...
>
> --
> Patrice
>
>
>
> .
>
 | 
Pages: 1
Prev: Report Parameters in SQL 2008
Next: SOAP Webservice Data Source (Input object type)