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