Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Rob Smith 34 posts 165 karma points
    Nov 29, 2012 @ 15:18
    Rob Smith
    0

    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?

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Nov 29, 2012 @ 15:36
    Richard Soeteman
    0

    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

  • Rob Smith 34 posts 165 karma points
    Nov 29, 2012 @ 17:56
    Rob Smith
    0

     

     

    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?

     

     

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Nov 30, 2012 @ 08:23
    Richard Soeteman
    0

    Set the properties in Excel to test and you should be good I guess?

Please Sign in or register to post replies

Write your reply to:

Draft