How do I get the correct date format for an import job?


1 comment

  • Official comment
    Saurabh Agashe

    In order to get the correct date, you must put in the correct date parse pattern when you bring in the data. While setting up the data link, you will get a preview of your data, along with the column types. Under the DATE column header, you will see there is a place to put your date pattern.

    If your date looks like 20110101 as you specified, you will want to enter YYYYmmdd. You can find more information on how to write date patterns here:

    Comment actions Permalink

Please sign in to leave a comment.