I am uploading Excel files created on a server to a sharepoint, using bat file, and when I do this a date field keeps changing date formats from dd/mm/yyyy to mm/dd/yyyy, onm server date format is dd/mm/yyyy. The sharepoint is a corporate installation and we do not have access to the server or settings. The only front-end settings I can change is regional settings - to UK format -that I thought would do the trick.
I changed it yesterday, uploaded a file and it seemed to retain the proper date format I want (dd/mm/yyyy) but now notice on another file on another site it is showing the mm/dd/yyyy format again.
Rechecked the regional settings and all are still UK setting on that site.
I don't know if there is an issue with the setting on this site as the other site appeared to work ok now.