Hello,
I am having a strange problem with one of our web service connections.
We've always used the standard SQL database connection and that worked just fine.
Now we are trying the web service because some people need to use the data outside the company.
(the connection is working fine! but…)
When I am trying to run a report, it is giving me the following error on a date filter.
Invoking the web service failed with the following message:
The filter "10/14/2016..12/16/2016" is not valid for the field date filter in the table item. The value "10/14/2016" can't be evaluated for the type date
When I see this message i'm thinking … why is he converting my date format 14/10/2016 into 10/14/2016 ? Because, yes I know there isn't a month 14 ;)
I am only having this problem with the web service, the sql database connection works flawless with the same report.
(strange right???)
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
I would start by looking at the Local Setting on the server running the NAV services, it appears to be using USA date format!
M -
Jet Reports Historic Posts Hi,
I would start by looking at the Local Setting on the server running the NAV services, it appears to be using USA date format!
M
Thanks for your reply.
I will check this and keep you posted -
Jet Reports Historic Posts After a long vacation i've checked this on the server.
–> this under region format.
The format used is : Dutch(Belgium) –> this should be correct.
I still have no clue why Jet is using the USA date format
Please sign in to leave a comment.