Hi
I upload sharepoint documents from a server to a sharepoint based in USA. The server is set to UK/EU date format dd/mm/yyyy and I have now set the sharepoint regional settings to UK date format.
In my excel I have say a range of dates in August
01/08/2012
02/08/2012
03/08/2012
04/08/2012
05/08/2012
06/08/2012
07/08/2012
09/08/2012
10/08/2012
11/08/2012
12/08/2012
For these dates when they go from the server copy to the upload on to sharepoint it is swapping the date from dd/mm/yyyy to mm/dd/yyyy so if I look at the dates in the filter in Excel they are showing as:
2012 > Jan > 08
2012 > Feb> 08
2012 > Mar > 08
2012 > Apr > 08
2012 > May > 08
2012 > Jun > 08
2012 > Jul > 08
2012 > Sept > 08
2012 > Oct > 08
2012 > Nov > 08
2012 > Dec > 08
Any dates with a day larger than 12 it shows the date correctly - dd/mm/yyyy such as:
13/08/2012
And in filter will be shown as:
2012 > Aug > 13
How can I "lock" - if that is the right word - the dates with months less than or equal 12 to dd/mm/yyyy format?
I know that if there is a day <= 12 then it takes the day to be month and then displays it as that. The problem seems to happen between upload and copy onto sharepoint.
Uploading is done by a BAT file, which copies all the files up to sharepoint.
Thanks
G
Bookmarks