ODATA date inport to Excel wrong

njward
njward Member Posts: 38
edited 2014-06-25 in NAV Three Tier
Hello, I have created a query in NAV and published it as a web service. It extracts data form the sales order header and lines. When I run the query in NAV the date is correct but when extracted to Excel the month is incorrect. E.g the query in NAV shows 27/07/2014 but when extracted to Excel using PowerPivot the date shows 27/06/2014.

This is really confusing me and I can't see anything wrong with what I have done. Can anyone offer any advise on what can be done to resolve this.

Any help/advise would be very much appreciated.

Thanks

Nick

Categories