Post reply

date parameter issue

  • March 15, 2013 at 5:32 am

    #275290

    Hi

    I have created a parameter with a called MonthEnding that has a datatype Date/Time. In my report parameter properties i have ticked the box to Allow Multiple Values.

    However when i view the report in the browser and go to select a month, the month format is as follows: 28/02/2013 00:00:00

    Is it possible to change the format to be 28 Feb 2013? The report parameters properties dont seem to have any options to be able to change this.

    In the database table the month format is as follows: 2013-02-28

    Thanks for you help in advance.

  • March 19, 2013 at 4:17 am

    #1598349

    Anyone Any idea on this?

    Thanks

  • March 20, 2013 at 6:26 am

    #1598861

    you need to convert / cast the field to just a date in the query that populates your parameter.

  • March 20, 2013 at 7:50 am

    #1598903

    Thanks for you suggestion Scott. I have added the following and it seems to do the same thing:

    SELECT DISTINCT CONVERT(DATETIME, MonthEnding, 106) AS MonthEnding

    FROM Sales

  • March 27, 2013 at 4:13 pm

    #1601410

    PLEASE ADD AS BELOW

    SELECT DISTINCT

    convert (varchar(12), MonthEnding) as MonthEnding

    FROM Sales

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply