Date in UK format (dd/mm/yyyy) in Excel importing as american (mm/dd/yyyy)
I'm trying to import an excel file where one of the columns is a mix of text and dates as some are "tbc", some are "12/05/2012 30/05/2012" - treated as text and some are "12/05/2012" which excel (being super useful) converts to a date.
When looking at the formula area is is showing correctly "12/05/2012" but when importing into Umbraco it gets changed to "05/12/2012"
I think it's a culture setting. Then the date get's parsed in the wrong format. CMSimport allows you to specify the date format, then it get's parsed against that format. Specify the format and it should work for you I guess.
Date in UK format (dd/mm/yyyy) in Excel importing as american (mm/dd/yyyy)
I'm trying to import an excel file where one of the columns is a mix of text and dates as some are "tbc", some are "12/05/2012 30/05/2012" - treated as text and some are "12/05/2012" which excel (being super useful) converts to a date.
When looking at the formula area is is showing correctly "12/05/2012" but when importing into Umbraco it gets changed to "05/12/2012"
Any ideas?
I think it's a culture setting. Then the date get's parsed in the wrong format. CMSimport allows you to specify the date format, then it get's parsed against that format. Specify the format and it should work for you I guess.
Best,
Richard
As the field contains a mix of dates and text I had to set it to a "textstring" in Umbraco so I don't get that option, only what to set it to if null.
I can't enforce an actual date as a start date as this often isn't the case. It has to be a textstring.
I suppose I'll just have to make sure Excel dosn't auto format the fied as a date somehow... unless you have any bright ideas?
Set the properties in Excel to test and you should be good I guess?
is working on a reply...