June 21, 2013 at 11:39 am
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
June 21, 2013 at 12:21 pm
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.
June 21, 2013 at 12:41 pm
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?
June 21, 2013 at 12:49 pm
convert(varchar(30),@variable,120)
just replace @variable with the column or value you want to format
August 8, 2013 at 1:02 pm
Hi,
You may try:
SELECT convert(varchar(30),Getdate(),121) --2013-08-08 19:01:19.733
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply