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: 2 days ago @ 4:55 AM
Points: 64, Visits: 1,246
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, June 25, 2014 9:30 AM
Points: 67, Visits: 342
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: 2 days ago @ 4:55 AM
Points: 64, Visits: 1,246
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, June 25, 2014 9:30 AM
Points: 67, Visits: 342

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

just replace @variable with the column or value you want to format
Post #1466348
Posted Thursday, August 8, 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: Thursday, October 9, 2014 1:35 PM
Points: 522, Visits: 238
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