Monday, March 19, 2012

Datetime parameter

I have a Datetime parameter from a dataset. It also shows the time but I
only need the date, is it possible somehow to change how it displays the
parameter. As what I can see it is only possible to choose datetime format.
I tried to convert it like this convert(datetime,period,105) as dateonly and
then use this field but it shows exactly the same !
Jackin the report, in the expression field , where you place the datetime field,
go to properties of the textbox,on the right hand side, go to standard
formatting, click on the date and select the format u want.
or u can go custom formatting too.
Hope This Helps
RP
"Jack Nielsen" wrote:
> I have a Datetime parameter from a dataset. It also shows the time but I
> only need the date, is it possible somehow to change how it displays the
> parameter. As what I can see it is only possible to choose datetime format.
> I tried to convert it like this convert(datetime,period,105) as dateonly and
> then use this field but it shows exactly the same !
> Jack
>
>

No comments:

Post a Comment