Post reply

Change Date format in Paramater

  • June 21, 2013 at 11:39 am

    #275464

    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

    #1626445

    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

    #1626451

    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

    #1626456

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

    just replace @variable with the column or value you want to format

  • August 8, 2013 at 1:02 pm

    #1639959

    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