ReportService Web Service Date Parameter Format

Hi all,
In my web service call, I pass the date value to the reporting services in
the format of yyyy-MM-dd. But the reporting service interpret the date value
in a strange way. When I select 9 Mar 2007, It convert the date to 3 Sep
2007. However, when I select 13 Mar 2007, It remain as 13 Mar 2007 !!!
The date format is the same when I use visual studio to launch the web
application. When I deploy it to IIS, I have encountered the above problem.
I have changed the web server locale to en-US and my report server is also
en-US. This makes no difference.
Could someone help? Thx.On Mar 9, 6:13 am, Cloud <C...@.discussions.microsoft.com> wrote:
> Hi all,
> In my web service call, I pass the date value to the reporting services in
> the format of yyyy-MM-dd. But the reporting service interpret the date value
> in a strange way. When I select 9 Mar 2007, It convert the date to 3 Sep
> 2007. However, when I select 13 Mar 2007, It remain as 13 Mar 2007 !!!
> The date format is the same when I use visual studio to launch the web
> application. When I deploy it to IIS, I have encountered the above problem.
> I have changed the web server locale to en-US and my report server is also
> en-US. This makes no difference.
> Could someone help? Thx.
Unfortunately, it sounds like it is a system regional setting issue.
I'm not very savvy in this area; but, have you checked all of the
related regional settings (incl. SQL Server's)? Perhaps another group
member can add a little more insight. Sorry I could not be of greater
assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Have you tried passing the date in with standard date format
In VB would be CDate("datestring").tostring("s")
On Mar 9, 7:33 am, "EMartinez" <emartinez...@.gmail.com> wrote:
> On Mar 9, 6:13 am, Cloud <C...@.discussions.microsoft.com> wrote:
> > Hi all,
> > In my web service call, I pass the date value to the reporting services in
> > the format of yyyy-MM-dd. But the reporting service interpret the date value
> > in a strange way. When I select 9 Mar 2007, It convert the date to 3 Sep
> > 2007. However, when I select 13 Mar 2007, It remain as 13 Mar 2007 !!!
> > The date format is the same when I use visual studio to launch the web
> > application. When I deploy it to IIS, I have encountered the above problem.
> > I have changed the web server locale to en-US and my report server is also
> > en-US. This makes no difference.
> > Could someone help? Thx.
> Unfortunately, it sounds like it is a system regional setting issue.
> I'm not very savvy in this area; but, have you checked all of the
> related regional settings (incl. SQL Server's)? Perhaps another group
> member can add a little more insight. Sorry I could not be of greater
> assistance.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer|||Hi All,
I have tried to change the format to "s", the result is still the same.
And I have logged the Soap messages in both cases (Visual Studio and IIS),
the Soap Messages are exactly the same.
Since the messages are same, the ReportService Web Service must get the
locale/dateformot information in other ways. Does anyone know how does the
ReportService Web Service determine the date format of a parameter?|||>Does anyone know how does the
> ReportService Web Service determine the date format of a parameter?
Looking at two versions of the spec they both say:
>>DateTime parameters, use ISO 8601 compatible values.
Docs say the same thing.
Are you sure that you are sending the values with leading 0's as you would
need to? I ask because you say:
>>When I select 9 Mar 2007, It convert the date to 3 Sep 2007. However, when
>>I select 13 Mar 2007, It remain as 13 Mar 2007 !!!
Notice that you are having a problem with the day value that is a single
digit, but not having a problem with the day value that is two digits. Not
sure if this is relevant or not.
Also, when you say "When I select", how exactly are you selecting the value,
what type of control? Just in case...
>L<
"Cloud" <Cloud@.discussions.microsoft.com> wrote in message
news:FF326B56-4D22-4F4B-B6ED-7C787BCF5047@.microsoft.com...
> Hi All,
> I have tried to change the format to "s", the result is still the same.
> And I have logged the Soap messages in both cases (Visual Studio and
> IIS),
> the Soap Messages are exactly the same.
> Since the messages are same, the ReportService Web Service must get the
> locale/dateformot information in other ways.