Uploading Excel to SharePoint Date Format Changes
Hi
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.
G
Re: Uploading Excel to SharePoint Date Format Changes
i really like date in format dd/mmm/yyyy as it can not be ambiguous, the only solution i can suggest is to loop through all dates to find which format the date is in then convert all if required
to confirm the date format find the first date where day is > 12, or if you know a value of a specific date within the file you can find the format of that (unless day and month are the same)