| Author |
Topic |
|
jamie
Aged Yak Warrior
542 Posts |
 Posted - 2007-11-15 : 09:36:10
|
| hi,my reports have been working fine up until a few days ago..all reports with a datetime parameter fails when the date is higher than 12/11/2007.( my queries format all dates to 'yyyy-mm-dd' by using :Convert(CHAR(10),MinTime,23))Then I am using datetime parameters to choose the dates.IF I type in 2007-11-15 it works, but when I choose the date from the calender it fails.do you know how I can solve this annoyance ?jamie |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-11-15 : 12:46:49
|
how is the calendar passing the date?
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-11-16 : 04:14:06
|
| it looks like the calender is placing the dates in us format mm/dd/yyyyI think it could be a setting issue, however all my regional settings are UK.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-11-21 : 02:32:46
|
| Have you checked for language settings of report as well? Also is this happening only locally or even after deploying to server? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-21 : 03:09:06
|
| You need to express your dates in YYYYMMDD format before sending to a tableMadhivananFailing to plan is Planning to fail |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-11-22 : 16:45:23
|
| When I saw the style 23 I noticed that but it must be a hidden feature as Query Analyzer does not complain about it but returns 2007-11-22.My system date setting is MM/DD/YYYYdeclare @MinTime datetimeselect @MinTime = getdate()select Convert(CHAR(10),@MinTime,23) |
|
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-11-23 : 05:17:54
|
| I think it must be a setting somewhere, because if I run the report on anoher server it works correctly. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-11-23 : 05:50:30
|
| As far as i know,you have basically two settings to check here. One the regional settings of pc where report is running and other one language settings in report properties of report.Have you checked both these settings? |
|
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-11-23 : 06:00:20
|
| yes. everytthing I can find is set as uk |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2007-11-23 : 06:36:11
|
| Are you getting this error only when report is run on preview mode. If yes, its a known bug with SSRS 2005[url]http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=112181&SiteID=1[/url] |
|
|
|
jamie
Aged Yak Warrior
542 Posts |
Posted - 2007-11-23 : 10:01:06
|
| thanks, this could be the problem ! |
|
|
|
|
date problems