Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change Date format in Paramater Expand / Collapse
Author
Message
Posted Friday, June 21, 2013 11:39 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 11:09 AM
Points: 64, Visits: 1,202
Hi

I was wondering if anyone knew how to change the Date/Time parameter in Reporting Services (2012) from the default style of dd/mm/yyyy to yyyy-mm-dd hh:mm:ss.xxx in the dropdown box of the report
For example changing the dropdown from 21/06/2013 to 2013-06-21 00:00:00.000
Thanks in advance

Chris
Post #1466325
Posted Friday, June 21, 2013 12:21 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:43 AM
Points: 64, Visits: 319
If you are receiving the value in the report as a parameter you should format it before the report. If you are filling the available values of the parameter for a dropdown then format it in the formula.
Post #1466336
Posted Friday, June 21, 2013 12:41 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 11:09 AM
Points: 64, Visits: 1,202
yes, I am filling the available values of the parameter for a dropdown - would you be able to point me to some resources on how format the time in the formula?

Post #1466343
Posted Friday, June 21, 2013 12:49 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 11:43 AM
Points: 64, Visits: 319

convert(varchar(30),@variable,120)

just replace @variable with the column or value you want to format
Post #1466348
Posted Thursday, August 08, 2013 1:02 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 12:46 PM
Points: 522, Visits: 229
Hi,

You may try:

SELECT convert(varchar(30),Getdate(),121) --2013-08-08 19:01:19.733
Post #1482538
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse