Excel Data Query stops at specific date

[willow1985]

I am not sure if anyone can answer this but I thought I would give it a shot.

I have no experience with data Queries. My IT department set up a data query to get a live feed of data from our ERP system. It would automatically refresh every time the excel book was opened with up to date data. IT did an update to the system but swears it should not have affected the Query, however it stopped automatically refreshing to the current date and stops at a specific date of Aug 20. This happens accross 5 excel spreadsheets and 5 different Queries.

IT claims it is excel thats the problem. Any idea what could cause this?
What information would you need from me to troubleshoot?

Thank you to anyone who could point me in the right direction or even help me explain it to my IT department.

 

[sandy666]

I didn't verifying that , to do that I should be there and check on live data
But everything you posted looks correct

 

[willow1985]

Thank you. Then I am puzzled to why it is not working but I will keep nudging IT. Thanks again

 

[sandy666]

You are welcome
Hope it will be solve soon
Have a nice day

 

[willow1985]

Was solved. IT changed the server name so I was referencing the wrong name. Thank you guys for verifying the query code though!

You guys are awesome!!

 

[sandy666]

You are welcome & thanks for the feedback