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

date parameter issue Expand / Collapse
Author
Message
Posted Friday, March 15, 2013 5:32 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 2:35 PM
Points: 110, Visits: 1,469
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.
Post #1431472
Posted Tuesday, March 19, 2013 4:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 2:35 PM
Points: 110, Visits: 1,469
Anyone Any idea on this?
Thanks
Post #1432552
Posted Wednesday, March 20, 2013 6:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:43 PM
Points: 234, Visits: 2,614
you need to convert / cast the field to just a date in the query that populates your parameter.
Post #1433170
Posted Wednesday, March 20, 2013 7:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 2:35 PM
Points: 110, Visits: 1,469
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

Post #1433219
Posted Wednesday, March 27, 2013 4:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 25, 2013 1:07 AM
Points: 7, Visits: 64
PLEASE ADD AS BELOW

SELECT DISTINCT
convert (varchar(12), MonthEnding) as MonthEnding
FROM Sales

Post #1436208
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse