DateTimePicker RS2005SP2 solution?

I read a lot of posts in this forum, but none of them provide a solution.

Probably it is related to SP2 as many report, I have SP2 as well...

A funny situation:
I have a report parameter @.date, datatype datetime, so I can use the datepicker control.

But, even when not using this @.date parameter in my dataset, I still get the error:

The value provided for the report parameter 'date' is not valid for its type. (rsReportParameterTypeMismatch)

Of course it has to do with regional settings and languages etc... But at my international client's site, workstations are in any regional setting and servers are in en-US, nothing I can do about that.

Come'on Microsoft, don't tell us this datePicker is only for the US market?

Thank You MS!

Apparently it is now solved in the Cumulative update package 2 for SQL Server 2005 Service Pack 2

See http://support.microsoft.com/kb/936305, bug n_ 50001284

datetime in SQL Server 2000 SP2

Hello!
I have datetime column <CreatedDate> in table <sale>.
Here' s some sample data for CreatedDate:
2004-04-30 15:56:12.390
2004-04-30 15:59:42.000
2004-04-30 15:58:42.100
2004-04-30 16:01:06.190
2004-04-30 16:01:59.820
When running query below I'm not getting any rows back:
select name, CreatedDate
from sale
where CreatedDate between '04/01/2004' and '04/30/2004'
But when changing '04/30/2004' to '05/01/2004' I' m getting rows back for CreaedDate '04/30/2004'.
From BOL:
BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of begin_expression and less than or equal to the value of end_expression.
Why sql server can't recognize '04/30/2004'?
Thanks,
Lena
Because '04/30/2004' really means '04/30/2004 00:00:00.000' and '2004-04-30
15:56:12.390' is greater than that.
Bojidar Alexandrov
"Lena" <anonymous@.discussions.microsoft.com> wrote in message
news:8AAFC89E-8E21-4A93-987E-F3D142BEC4D1@.microsoft.com...
> Hello!
> I have datetime column <CreatedDate> in table <sale>.
> Here' s some sample data for CreatedDate:
> 2004-04-30 15:56:12.390
> 2004-04-30 15:59:42.000
> 2004-04-30 15:58:42.100
> 2004-04-30 16:01:06.190
> 2004-04-30 16:01:59.820
> When running query below I'm not getting any rows back:
> select name, CreatedDate
> from sale
> where CreatedDate between '04/01/2004' and '04/30/2004'
> But when changing '04/30/2004' to '05/01/2004' I' m getting rows back for
CreaedDate '04/30/2004'.
> From BOL:
> BETWEEN returns TRUE if the value of test_expression is greater than or
equal to the value of begin_expression and less than or equal to the value
of end_expression.
>
> Why sql server can't recognize '04/30/2004'?
> Thanks,
> Lena
>
>
|||I suggest you check out my article about datetime at:
http://www.karaszi.com/sqlserver/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Lena" <anonymous@.discussions.microsoft.com> wrote in message
news:8AAFC89E-8E21-4A93-987E-F3D142BEC4D1@.microsoft.com...
> Hello!
> I have datetime column <CreatedDate> in table <sale>.
> Here' s some sample data for CreatedDate:
> 2004-04-30 15:56:12.390
> 2004-04-30 15:59:42.000
> 2004-04-30 15:58:42.100
> 2004-04-30 16:01:06.190
> 2004-04-30 16:01:59.820
> When running query below I'm not getting any rows back:
> select name, CreatedDate
> from sale
> where CreatedDate between '04/01/2004' and '04/30/2004'
> But when changing '04/30/2004' to '05/01/2004' I' m getting rows back for CreaedDate '04/30/2004'.
> From BOL:
> BETWEEN returns TRUE if the value of test_expression is greater than or equal to the value of
begin_expression and less than or equal to the value of end_expression.
>
> Why sql server can't recognize '04/30/2004'?
> Thanks,
> Lena
>
>
|||Is there a way to use some date function in where clause so sql server will return all rows with CreatedDate for 04/30/2004 and will ignore time stamp?
Thanks
|||Lena,
This issue(plus many others) are discussed in the link that Tibor posted.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Lena" <anonymous@.discussions.microsoft.com> wrote in message
news:BC32384D-6877-4DCF-9861-712082375A2D@.microsoft.com...
> Is there a way to use some date function in where clause so sql server
will return all rows with CreatedDate for 04/30/2004 and will ignore time
stamp?
> Thanks

datetime in SQL Server 2000 SP2

Hello!
I have datetime column <CreatedDate> in table <sale>.
Here' s some sample data for CreatedDate:
2004-04-30 15:56:12.390
2004-04-30 15:59:42.000
2004-04-30 15:58:42.100
2004-04-30 16:01:06.190
2004-04-30 16:01:59.820
When running query below I'm not getting any rows back:
select name, CreatedDate
from sale
where CreatedDate between '04/01/2004' and '04/30/2004'
But when changing '04/30/2004' to '05/01/2004' I' m getting rows back for Cr
eaedDate '04/30/2004'.
From BOL:
BETWEEN returns TRUE if the value of test_expression is greater than or equa
l to the value of begin_expression and less than or equal to the value of en
d_expression.
Why sql server can't recognize '04/30/2004'?
Thanks,
LenaBecause '04/30/2004' really means '04/30/2004 00:00:00.000' and '2004-04-30
15:56:12.390' is greater than that.
Bojidar Alexandrov
"Lena" <anonymous@.discussions.microsoft.com> wrote in message
news:8AAFC89E-8E21-4A93-987E-F3D142BEC4D1@.microsoft.com...
> Hello!
> I have datetime column <CreatedDate> in table <sale>.
> Here' s some sample data for CreatedDate:
> 2004-04-30 15:56:12.390
> 2004-04-30 15:59:42.000
> 2004-04-30 15:58:42.100
> 2004-04-30 16:01:06.190
> 2004-04-30 16:01:59.820
> When running query below I'm not getting any rows back:
> select name, CreatedDate
> from sale
> where CreatedDate between '04/01/2004' and '04/30/2004'
> But when changing '04/30/2004' to '05/01/2004' I' m getting rows back for
CreaedDate '04/30/2004'.
> From BOL:
> BETWEEN returns TRUE if the value of test_expression is greater than or
equal to the value of begin_expression and less than or equal to the value
of end_expression.
>
> Why sql server can't recognize '04/30/2004'?
> Thanks,
> Lena
>
>|||I suggest you check out my article about datetime at:
http://www.karaszi.com/sqlserver/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Lena" <anonymous@.discussions.microsoft.com> wrote in message
news:8AAFC89E-8E21-4A93-987E-F3D142BEC4D1@.microsoft.com...
> Hello!
> I have datetime column <CreatedDate> in table <sale>.
> Here' s some sample data for CreatedDate:
> 2004-04-30 15:56:12.390
> 2004-04-30 15:59:42.000
> 2004-04-30 15:58:42.100
> 2004-04-30 16:01:06.190
> 2004-04-30 16:01:59.820
> When running query below I'm not getting any rows back:
> select name, CreatedDate
> from sale
> where CreatedDate between '04/01/2004' and '04/30/2004'
> But when changing '04/30/2004' to '05/01/2004' I' m getting rows back for
CreaedDate '04/30/2004'.
> From BOL:
> BETWEEN returns TRUE if the value of test_expression is greater than or equal to t
he value of
begin_expression and less than or equal to the value of end_expression.
>
> Why sql server can't recognize '04/30/2004'?
> Thanks,
> Lena
>
>|||Is there a way to use some date function in where clause so sql server will
return all rows with CreatedDate for 04/30/2004 and will ignore time stamp?
Thanks|||Lena,
This issue(plus many others) are discussed in the link that Tibor posted.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Lena" <anonymous@.discussions.microsoft.com> wrote in message
news:BC32384D-6877-4DCF-9861-712082375A2D@.microsoft.com...
> Is there a way to use some date function in where clause so sql server
will return all rows with CreatedDate for 04/30/2004 and will ignore time
stamp?
> Thanks

datetime + sp2?

In report designer using the data tab when testing the datetime parameters
the datetime is being shown as UK locale and the data is being rendered
properly (UK locale). However, if I then switch to the preview tab the
datetime parameters are being formatted US locale. If I deploy the result is
the same, US style locale.
I have set the report language to English UK the machine locale is set to
UK, IE is set to en-gb. What can I do next?
I was wondering if this is an sp2 issue as sp1 fixed the locale issues.
Thanks
FrankWhat is the VS languge set to?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank Ashley" <aa@.aa.com> wrote in message
news:eCL9Mj2SFHA.2560@.TK2MSFTNGP09.phx.gbl...
> In report designer using the data tab when testing the datetime parameters
> the datetime is being shown as UK locale and the data is being rendered
> properly (UK locale). However, if I then switch to the preview tab the
> datetime parameters are being formatted US locale. If I deploy the result
> is the same, US style locale.
> I have set the report language to English UK the machine locale is set to
> UK, IE is set to en-gb. What can I do next?
> I was wondering if this is an sp2 issue as sp1 fixed the locale issues.
> Thanks
> Frank
>
>|||VS2003 is set to
Tools | International Settings | Language | Same as Microsoft office
(language neutral)
Office 2003 Enabled langauge is set to English (UK) and default behaviour is
set to English UK.
Hope this helps.
Frank
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:%23n2x5x6SFHA.3188@.TK2MSFTNGP09.phx.gbl...
> What is the VS languge set to?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Frank Ashley" <aa@.aa.com> wrote in message
> news:eCL9Mj2SFHA.2560@.TK2MSFTNGP09.phx.gbl...
>> In report designer using the data tab when testing the datetime
>> parameters the datetime is being shown as UK locale and the data is being
>> rendered properly (UK locale). However, if I then switch to the preview
>> tab the datetime parameters are being formatted US locale. If I deploy
>> the result is the same, US style locale.
>> I have set the report language to English UK the machine locale is set to
>> UK, IE is set to en-gb. What can I do next?
>> I was wondering if this is an sp2 issue as sp1 fixed the locale issues.
>> Thanks
>> Frank
>>
>>
>|||Can you try a non-English locale? I'm stumped.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank Ashley" <aa@.aa.com> wrote in message
news:uUaOA$7SFHA.1044@.TK2MSFTNGP10.phx.gbl...
> VS2003 is set to
> Tools | International Settings | Language | Same as Microsoft office
> (language neutral)
> Office 2003 Enabled langauge is set to English (UK) and default behaviour
> is set to English UK.
> Hope this helps.
> Frank
>
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
> news:%23n2x5x6SFHA.3188@.TK2MSFTNGP09.phx.gbl...
>> What is the VS languge set to?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Frank Ashley" <aa@.aa.com> wrote in message
>> news:eCL9Mj2SFHA.2560@.TK2MSFTNGP09.phx.gbl...
>> In report designer using the data tab when testing the datetime
>> parameters the datetime is being shown as UK locale and the data is
>> being rendered properly (UK locale). However, if I then switch to the
>> preview tab the datetime parameters are being formatted US locale. If I
>> deploy the result is the same, US style locale.
>> I have set the report language to English UK the machine locale is set
>> to UK, IE is set to en-gb. What can I do next?
>> I was wondering if this is an sp2 issue as sp1 fixed the locale issues.
>> Thanks
>> Frank
>>
>>
>>
>|||Hi Brian,
I changed the locale to Finnish and the dates were rendered as dd.mm.yyyy
hh:mm:ss in the data tab but still the drop down on the preview tab showed
mm/dd/yyyy hh:mm:ss
I then tried removing Reporting Services and re-installing (going straight
to sp2, bypassing sp1) but still the same results.
regards
Frank
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:u1c$ioNTFHA.2828@.TK2MSFTNGP10.phx.gbl...
> Can you try a non-English locale? I'm stumped.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Frank Ashley" <aa@.aa.com> wrote in message
> news:uUaOA$7SFHA.1044@.TK2MSFTNGP10.phx.gbl...
>> VS2003 is set to
>> Tools | International Settings | Language | Same as Microsoft office
>> (language neutral)
>> Office 2003 Enabled langauge is set to English (UK) and default behaviour
>> is set to English UK.
>> Hope this helps.
>> Frank
>>
>> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
>> news:%23n2x5x6SFHA.3188@.TK2MSFTNGP09.phx.gbl...
>> What is the VS languge set to?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Frank Ashley" <aa@.aa.com> wrote in message
>> news:eCL9Mj2SFHA.2560@.TK2MSFTNGP09.phx.gbl...
>> In report designer using the data tab when testing the datetime
>> parameters the datetime is being shown as UK locale and the data is
>> being rendered properly (UK locale). However, if I then switch to the
>> preview tab the datetime parameters are being formatted US locale. If I
>> deploy the result is the same, US style locale.
>> I have set the report language to English UK the machine locale is set
>> to UK, IE is set to en-gb. What can I do next?
>> I was wondering if this is an sp2 issue as sp1 fixed the locale issues.
>> Thanks
>> Frank
>>
>>
>>
>>
>